VIEW: APPS.PAY_XLA_EST_OR_PAYM_ACTIONS_V

Source

View Text - Preformatted

SELECT PXE.EVENT_ID, TGL_AA.ASSIGNMENT_ACTION_ID, COST_AA.ASSIGNMENT_ACTION_ID, COST_PA.ACTION_TYPE, PXE.ACCOUNTING_DATE, 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

View Text - HTML Formatted

SELECT PXE.EVENT_ID
, TGL_AA.ASSIGNMENT_ACTION_ID
, COST_AA.ASSIGNMENT_ACTION_ID
, COST_PA.ACTION_TYPE
, PXE.ACCOUNTING_DATE
, 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