VIEW: APPS.PAY_XLA_COST_ACTIONS_V

Source

View Text - Preformatted

SELECT PXE.EVENT_ID, TGL_AA.ASSIGNMENT_ACTION_ID, COST_AA.ASSIGNMENT_ACTION_ID, RUN_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(RUN_PA.BUSINESS_GROUP_ID, RUN_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, PAY_ACTION_CLASSIFICATIONS COST_CLA, PAY_ACTION_INTERLOCKS RUN_LOCK, PAY_ASSIGNMENT_ACTIONS RUN_AA, PAY_PAYROLL_ACTIONS RUN_PA, PAY_ACTION_CLASSIFICATIONS RUN_CLA, 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 = COST_CLA.ACTION_TYPE AND COST_CLA.CLASSIFICATION_NAME = 'TRANSGL' AND RUN_LOCK.LOCKING_ACTION_ID = TGL_AA.ASSIGNMENT_ACTION_ID AND RUN_AA.ASSIGNMENT_ACTION_ID = RUN_LOCK.LOCKED_ACTION_ID AND RUN_PA.PAYROLL_ACTION_ID = RUN_AA.PAYROLL_ACTION_ID AND RUN_PA.ACTION_TYPE = RUN_CLA.ACTION_TYPE AND RUN_CLA.CLASSIFICATION_NAME = 'COSTED' AND ASG.ASSIGNMENT_ID = TGL_AA.ASSIGNMENT_ID AND RUN_PA.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE AND PER.PERSON_ID = ASG.PERSON_ID AND RUN_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 RUN_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
, RUN_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(RUN_PA.BUSINESS_GROUP_ID
, RUN_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
, PAY_ACTION_CLASSIFICATIONS COST_CLA
, PAY_ACTION_INTERLOCKS RUN_LOCK
, PAY_ASSIGNMENT_ACTIONS RUN_AA
, PAY_PAYROLL_ACTIONS RUN_PA
, PAY_ACTION_CLASSIFICATIONS RUN_CLA
, 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 = COST_CLA.ACTION_TYPE
AND COST_CLA.CLASSIFICATION_NAME = 'TRANSGL'
AND RUN_LOCK.LOCKING_ACTION_ID = TGL_AA.ASSIGNMENT_ACTION_ID
AND RUN_AA.ASSIGNMENT_ACTION_ID = RUN_LOCK.LOCKED_ACTION_ID
AND RUN_PA.PAYROLL_ACTION_ID = RUN_AA.PAYROLL_ACTION_ID
AND RUN_PA.ACTION_TYPE = RUN_CLA.ACTION_TYPE
AND RUN_CLA.CLASSIFICATION_NAME = 'COSTED'
AND ASG.ASSIGNMENT_ID = TGL_AA.ASSIGNMENT_ID
AND RUN_PA.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND PER.PERSON_ID = ASG.PERSON_ID
AND RUN_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 RUN_PA.EFFECTIVE_DATE BETWEEN PAY.EFFECTIVE_START_DATE
AND PAY.EFFECTIVE_END_DATE