View: PAY_XLA_EST_OR_PAYM_ACTIONS_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_XLA_EST_OR_PAYM_ACTIONS_V

View Text

SELECT PXE.EVENT_ID
, TGL_AA.ASSIGNMENT_ACTION_ID
, COST_AA.ASSIGNMENT_ACTION_ID
, COST_PA.ACTION_TYPE
, PER.FULL_NAME
, ASG.ASSIGNMENT_NUMBER
, JOB.NAME
, GRADE.NAME
, POS.NAME
, GRP.GROUP_NAME
, ORG.NAME
, PAY.PAYROLL_NAME
, NULL
, PAY_SLA_PKG.GET_CONVERSION_TYPE(COST_PA.BUSINESS_GROUP_ID
, COST_PA.EFFECTIVE_DATE)
, TO_CHAR(PXE.ACCOUNTING_DATE
, 'YYYY/MM/DD')
FROM PAY_XLA_EVENTS PXE
, PAY_ASSIGNMENT_ACTIONS TGL_AA
, PAY_ACTION_INTERLOCKS COST_LOCK
, PAY_ASSIGNMENT_ACTIONS COST_AA
, PAY_PAYROLL_ACTIONS COST_PA
, PER_ALL_ASSIGNMENTS_F ASG
, PER_ALL_PEOPLE_F PER
, PER_JOBS_TL JOB
, PER_GRADES_TL GRADE
, HR_ALL_POSITIONS_F_TL POS
, PAY_PEOPLE_GROUPS GRP
, HR_ALL_ORGANIZATION_UNITS_TL ORG
, PAY_ALL_PAYROLLS_F PAY
WHERE TGL_AA.ASSIGNMENT_ACTION_ID = PXE.ASSIGNMENT_ACTION_ID
AND COST_LOCK.LOCKING_ACTION_ID = TGL_AA.ASSIGNMENT_ACTION_ID
AND COST_AA.ASSIGNMENT_ACTION_ID = COST_LOCK.LOCKED_ACTION_ID
AND COST_PA.PAYROLL_ACTION_ID = COST_AA.PAYROLL_ACTION_ID
AND COST_PA.ACTION_TYPE IN ('EC'
, 'CP')
AND ASG.ASSIGNMENT_ID = TGL_AA.ASSIGNMENT_ID
AND COST_PA.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND PER.PERSON_ID = ASG.PERSON_ID
AND COST_PA.EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND JOB.JOB_ID (+) = ASG.JOB_ID
AND JOB.LANGUAGE (+) = USERENV('LANG')
AND GRADE.GRADE_ID (+) = ASG.GRADE_ID
AND GRADE.LANGUAGE (+) = USERENV('LANG')
AND POS.POSITION_ID (+) = ASG.POSITION_ID
AND POS.LANGUAGE (+) = USERENV('LANG')
AND GRP.PEOPLE_GROUP_ID (+) = ASG.PEOPLE_GROUP_ID
AND ORG.ORGANIZATION_ID = ASG.ORGANIZATION_ID
AND ORG.LANGUAGE = USERENV('LANG')
AND PAY.PAYROLL_ID = ASG.PAYROLL_ID
AND COST_PA.EFFECTIVE_DATE BETWEEN PAY.EFFECTIVE_START_DATE
AND PAY.EFFECTIVE_END_DATE

Columns