View: PAYBV_PAYROLL_ACT_RR_ENET_DET

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

View Text

SELECT PBG.NAME BUSINESS_GROUP_NAME
, PBG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PPF.PERSON_ID PERSON_ID
, PPF.FULL_NAME EMPLOYEE_NAME
, PPF.FIRST_NAME FIRST_NAME
, PPF.LAST_NAME LAST_NAME
, PPF.MIDDLE_NAMES MIDDLE_NAME
, PPF.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PAF.ASSIGNMENT_ID ASSIGNMENT_ID
, PAF.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, PG.NAME GRADE_NAME
, PP.NAME POSITION_NAME
, PJ.NAME JOB_NAME
, PPOF.PAYROLL_NAME PAYROLL_NAME
, PPOF.PAYROLL_ID PAYROLL_ID
, HOU.NAME HR_ORGANIZATION_NAME
, PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PPA.PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, PPA.DATE_EARNED DATE_EARNED
, PPA.EFFECTIVE_DATE EFFECTIVE_DATE
, NVL(PRT.RUN_TYPE_NAME
, PRT1.RUN_TYPE_NAME) RUN_TYPE
, PRT1.RUN_TYPE_NAME RUN_COMPONENT
, PEC.CLASSIFICATION_NAME CLASSIFICATION_NAME_CODE
, PECTL.CLASSIFICATION_NAME CLASSIFICATION_NAME
, TO_CHAR(PEC.DEFAULT_PRIORITY) CLASS_DEFAULT_PRIORITY
, PETTL.ELEMENT_NAME ELEMENT_NAME
, NVL(PETTL.REPORTING_NAME
, PETTL.ELEMENT_NAME) REPORTING_NAME
, PIVTL.NAME INPUT_VALUE_NAME
, PIV.UOM UNIT_OF_MEASURE
, PRRV.RESULT_VALUE RESULT_VALUE
, PBG.LEGISLATION_CODE LEGISLATION_CODE
, CASE WHEN PPA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PPA.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_ASSIGNMENTS_F PAF
, PER_PEOPLE_F PPF
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_INPUT_VALUES_F PIV
, PAY_INPUT_VALUES_F_TL PIVTL
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_RUN_RESULTS PRR
, PAY_RUN_RESULT_VALUES PRRV
, PAY_RUN_TYPES_F PRT
, PAY_RUN_TYPES_F PRT1
, PAY_PAYROLLS_F PPOF
, PER_PERIODS_OF_SERVICE PPOS
, PAY_ELEMENT_CLASSIFICATIONS PEC
, PAY_ELEMENT_CLASSIFICATIONS_TL PECTL
, PAY_PAYROLL_ACTIONS PPA
, PER_BUSINESS_GROUPS PBG
, HR_ORGANIZATION_UNITS HOU
, PER_GRADES PG
, PER_JOBS PJ
, PER_POSITIONS PP
WHERE PBG.BUSINESS_GROUP_ID = PPF.BUSINESS_GROUP_ID
AND HOU.ORGANIZATION_ID = PAF.ORGANIZATION_ID
AND PPF.PERSON_ID = PAF.PERSON_ID
AND PEC.CLASSIFICATION_ID = PECTL.CLASSIFICATION_ID
AND PECTL.LANGUAGE = USERENV('LANG')
AND PPA.EFFECTIVE_DATE BETWEEN PPOF.EFFECTIVE_START_DATE
AND PPOF.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND NVL(PPA.DATE_EARNED
, PPA.EFFECTIVE_DATE) BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND NVL(PPA.DATE_EARNED
, PPA.EFFECTIVE_DATE) BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN NVL(PRT.EFFECTIVE_START_DATE
, PPA.EFFECTIVE_DATE)
AND NVL(PRT.EFFECTIVE_END_DATE
, PPA.EFFECTIVE_DATE)
AND PPA.EFFECTIVE_DATE BETWEEN NVL(PRT1.EFFECTIVE_START_DATE
, PPA.EFFECTIVE_DATE)
AND NVL(PRT1.EFFECTIVE_END_DATE
, PPA.EFFECTIVE_DATE)
AND PAF.PERIOD_OF_SERVICE_ID = PPOS.PERIOD_OF_SERVICE_ID
AND PPF.PERSON_ID = PPOS.PERSON_ID
AND PG.GRADE_ID (+)= PAF.GRADE_ID
AND PP.POSITION_ID (+)= PAF.POSITION_ID
AND PJ.JOB_ID (+)= PAF.JOB_ID
AND (PET.BUSINESS_GROUP_ID = PAF.BUSINESS_GROUP_ID OR PET.LEGISLATION_CODE = PBG.LEGISLATION_CODE OR (PET.BUSINESS_GROUP_ID IS NULL
AND PET.LEGISLATION_CODE IS NULL))
AND PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID
AND PPOF.PAYROLL_ID = PAF.PAYROLL_ID
AND PIV.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV('LANG')
AND PETTL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PAF.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PRR.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PRR.STATUS IN ('P'
, 'PA')
AND PPA.ACTION_TYPE IN ('Q'
, 'R'
, 'B'
, 'V')
AND PRR.RUN_RESULT_ID = PRRV.RUN_RESULT_ID
AND PRRV.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PRT.RUN_TYPE_ID (+) = PPA.RUN_TYPE_ID
AND PRT1.RUN_TYPE_ID (+)= PAA.RUN_TYPE_ID
AND PIVTL.LANGUAGE = USERENV('LANG')
AND PIVTL.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID UNION ALL SELECT PBG.NAME BUSINESS_GROUP_NAME
, PBG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PPF.PERSON_ID PERSON_ID
, PPF.FULL_NAME EMPLOYEE_NAME
, PPF.FIRST_NAME FIRST_NAME
, PPF.LAST_NAME LAST_NAME
, PPF.MIDDLE_NAMES MIDDLE_NAME
, PPF.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PAF.ASSIGNMENT_ID ASSIGNMENT_ID
, PAF.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, PG.NAME GRADE_NAME
, PP.NAME POSITION_NAME
, PJ.NAME JOB_NAME
, PPOF.PAYROLL_NAME PAYROLL_NAME
, PPOF.PAYROLL_ID PAYROLL_ID
, HOU.NAME HR_ORGANIZATION_NAME
, PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PPA.PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, PPA.DATE_EARNED DATE_EARNED
, PPA.EFFECTIVE_DATE EFFECTIVE_DATE
, NVL(PRT.RUN_TYPE_NAME
, PRT1.RUN_TYPE_NAME) RUN_TYPE
, PRT1.RUN_TYPE_NAME RUN_COMPONENT
, PBT.BALANCE_NAME_CODE CLASSIFICATION_NAME_CODE
, PBT.BALANCE_NAME CLASSIFICATION_NAME
, TO_CHAR(50000) CLASS_DEFAULT_PRIORITY
, PBT.BALANCE_NAME ELEMENT_NAME
, PBT.BALANCE_NAME REPORTING_NAME
, HR_GENERAL.DECODE_LOOKUP('NAME_TRANSLATIONS'
, 'PAY VALUE') INPUT_VALUE_NAME
, 'M' UNIT_OF_MEASURE
, TO_CHAR(PAY_IN_TAX_UTILS.GET_BALANCE_VALUE( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_NAME_CODE
, '_ASG_RUN'
, 'NULL'
, 'NULL' )) RESULT_VALUE
, PBG.LEGISLATION_CODE LEGISLATION_CODE
, CASE WHEN PPA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PPA.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_ASSIGNMENTS_F PAF
, PER_PEOPLE_F PPF
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_PAYROLLS_F PPOF
, PER_PERIODS_OF_SERVICE PPOS
, PAY_PAYROLL_ACTIONS PPA
, PAY_RUN_TYPES_F PRT
, PAY_RUN_TYPES_F PRT1
, PER_BUSINESS_GROUPS PBG
, HR_ORGANIZATION_UNITS HOU
, PER_GRADES PG
, PER_JOBS PJ
, PER_POSITIONS PP
, (SELECT PBT.BALANCE_NAME BALANCE_NAME_CODE
, PBTL.BALANCE_NAME
, PBT.LEGISLATION_CODE
FROM PAY_BALANCE_TYPES PBT
, PAY_BALANCE_TYPES_TL PBTL
WHERE PBT.ASSIGNMENT_REMUNERATION_FLAG = 'Y'
AND PBTL.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
AND PBTL.LANGUAGE = USERENV('LANG')) PBT
WHERE PBG.BUSINESS_GROUP_ID = PPF.BUSINESS_GROUP_ID
AND HOU.ORGANIZATION_ID = PAF.ORGANIZATION_ID
AND PPF.PERSON_ID = PAF.PERSON_ID
AND PBT.LEGISLATION_CODE = PBG.LEGISLATION_CODE
AND PPA.EFFECTIVE_DATE BETWEEN PPOF.EFFECTIVE_START_DATE
AND PPOF.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN NVL(PRT.EFFECTIVE_START_DATE
, PPA.EFFECTIVE_DATE)
AND NVL(PRT.EFFECTIVE_END_DATE
, PPA.EFFECTIVE_DATE)
AND PPA.EFFECTIVE_DATE BETWEEN NVL(PRT1.EFFECTIVE_START_DATE
, PPA.EFFECTIVE_DATE)
AND NVL(PRT1.EFFECTIVE_END_DATE
, PPA.EFFECTIVE_DATE)
AND PAF.PERIOD_OF_SERVICE_ID = PPOS.PERIOD_OF_SERVICE_ID
AND PPF.PERSON_ID = PPOS.PERSON_ID
AND PG.GRADE_ID (+)= PAF.GRADE_ID
AND PP.POSITION_ID (+)= PAF.POSITION_ID
AND PJ.JOB_ID (+)= PAF.JOB_ID
AND PPOF.PAYROLL_ID = PAF.PAYROLL_ID
AND PAF.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('Q'
, 'R'
, 'B'
, 'V')
AND PRT.RUN_TYPE_ID (+) = PPA.RUN_TYPE_ID
AND PRT1.RUN_TYPE_ID (+)= PAA.RUN_TYPE_ID
AND PAA.SOURCE_ACTION_ID = PAA2.ASSIGNMENT_ACTION_ID
AND PAA2.SOURCE_ACTION_ID IS NULL WITH READ ONLY

Columns