View: PAYBV_PAYROLL_ACT_RR_EMP_DET

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

View Text

SELECT HR_BIS.BIS_DECODE_LOOKUP('ACTION_TYPE'
, PPA.ACTION_TYPE) ACTION_TYPE
, PPA.EFFECTIVE_DATE
, PPA.BUSINESS_GROUP_ID
, PPA.DATE_EARNED
, PPA.PAYROLL_ACTION_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.TAX_UNIT_ID
, PAA.ASSIGNMENT_ID
, PF.PAYROLL_NAME
, PF.PAYROLL_ID
, PPF.FULL_NAME
, PPF.FIRST_NAME
, PPF.LAST_NAME
, PPF.MIDDLE_NAMES
, PPF.EMPLOYEE_NUMBER
, PPF.NATIONAL_IDENTIFIER
, PAF.ASSIGNMENT_NUMBER
, PPF.DATE_OF_BIRTH
, PPF.SEX
, PPF.ORIGINAL_DATE_OF_HIRE
, PPF.PROJECTED_START_DATE LATEST_HIRE_DATE
, PPF.PERSON_ID
, HR_BIS.BIS_DECODE_LOOKUP('EMP_CAT'
, PAF.EMPLOYMENT_CATEGORY) EMPLOYMENT_CATEGORY
, PETTL.ELEMENT_NAME
, NVL(PETTL.REPORTING_NAME
, PETTL.ELEMENT_NAME) REPORTING_NAME
, PET.ELEMENT_TYPE_ID
, PIVTL.NAME INPUT_VALUE_NAME
, HR_BIS.BIS_DECODE_LOOKUP('UNITS'
, UOM) UNIT_OF_MEASURE
, PIV.INPUT_VALUE_ID
, PRRV.RESULT_VALUE
, PCS.CONSOLIDATION_SET_NAME
, PCS.CONSOLIDATION_SET_ID
, PAY_COSTING_DETAIL_REP_PKG.GET_COSTING_TAX_UNIT_NAME( PAA.TAX_UNIT_ID) GRE_NAME
, HOU_ORG.NAME ORGANIZATION
, HL.LOCATION_ID LOCATION_ID
, HL.LOCATION_CODE LOCATION_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 PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, PER_ASSIGNMENTS_F PAF
, PER_PEOPLE_F PPF
, PAY_PAYROLLS_F PF
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_INPUT_VALUES_F PIV
, PAY_RUN_RESULT_VALUES PRRV
, PAY_RUN_RESULTS PRR
, PAY_INPUT_VALUES_F_TL PIVTL
, PAY_CONSOLIDATION_SETS PCS
, HR_ORGANIZATION_UNITS HOU_ORG
, HR_LOCATIONS HL
WHERE PF.PAYROLL_ID = PAF.PAYROLL_ID
AND PPA.EFFECTIVE_DATE BETWEEN PF.EFFECTIVE_START_DATE
AND PF.EFFECTIVE_END_DATE
AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PAF.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PPA.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PPF.PERSON_ID = PAF.PERSON_ID
AND PPA.EFFECTIVE_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PIVTL.LANGUAGE = USERENV('LANG')
AND PIVTL.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PRRV.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PIV.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PRR.RUN_RESULT_ID = PRRV.RUN_RESULT_ID
AND PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PET.ELEMENT_TYPE_ID = PRR.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV('LANG')
AND PETTL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
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 PCS.CONSOLIDATION_SET_ID = PF.CONSOLIDATION_SET_ID
AND HOU_ORG.ORGANIZATION_ID = PAF.ORGANIZATION_ID
AND HL.LOCATION_ID = PAF.LOCATION_ID

Columns