PAY_XLA_ESTIMATE_ACTIONS_V

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name
EVENT_ID PAYROLL_REL_ACTION_ID COST_ACTION_ID COST_ACTION_TYPE ACCOUNTING_DATE PERSON_NAME PAYROLL_NAME CONVERSION_RATE CONVERSION_RATE_TYPE TRANSACTION_DATE PAYROLL_ID REVERSAL_FLAG

Query

SQL_Statement

SELECT PXE.EVENT_ID, TGL_RA.PAYROLL_REL_ACTION_ID, COST_RA.PAYROLL_REL_ACTION_ID COST_ACTION_ID, COST_PA.ACTION_TYPE COST_ACTION_TYPE, PXE.ACCOUNTING_DATE, PAY_SLA_PKG.GET_PERSON_NAME(PER.FULL_NAME) PERSON_NAME, PAY.PAYROLL_NAME, null CONVERSION_RATE, PAY_SLA_PKG.GET_CONVERSION_TYPE(COST_PA.LEGISLATIVE_DATA_GROUP_ID, COST_PA.EFFECTIVE_DATE) CONVERSION_RATE_TYPE, to_char(PXE.ACCOUNTING_DATE, 'YYYY/MM/DD') TRANSACTION_DATE, PXE.PAYROLL_ID, PXE.REVERSAL_FLAG FROM PAY_XLA_EVENTS PXE, PAY_PAYROLL_REL_ACTIONS TGL_RA, PAY_ACTION_INTERLOCKS COST_LOCK, PAY_PAYROLL_REL_ACTIONS COST_RA, PAY_PAYROLL_ACTIONS COST_PA, PAY_PAY_RELATIONSHIPS_DN PPR, PER_PERSON_NAMES_F_V PER, PAY_ALL_PAYROLLS_F PAY WHERE TGL_RA.PAYROLL_REL_ACTION_ID = PXE.PAYROLL_REL_ACTION_ID AND COST_LOCK.LOCKING_ACTION_ID = TGL_RA.PAYROLL_REL_ACTION_ID AND COST_RA.PAYROLL_REL_ACTION_ID = COST_LOCK.LOCKED_ACTION_ID AND COST_PA.PAYROLL_ACTION_ID = COST_RA.PAYROLL_ACTION_ID AND COST_PA.ACTION_TYPE = 'EC' AND PPR.PAYROLL_RELATIONSHIP_ID = TGL_RA.PAYROLL_RELATIONSHIP_ID AND PER.PERSON_ID (+) = PPR.PERSON_ID AND COST_PA.EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE (+) AND PER.EFFECTIVE_END_DATE (+) AND PAY.PAYROLL_ID = COST_PA.PAYROLL_ID AND COST_PA.EFFECTIVE_DATE BETWEEN PAY.EFFECTIVE_START_DATE AND PAY.EFFECTIVE_END_DATE