View: HRFV_ACCRUAL_VALUES

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_ACCRUAL_VALUES

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PAP.ACCRUAL_PLAN_NAME ACCRUAL_PLAN_NAME
, DECODE( DUMMY.TYPE
, 1
, PER_VIEWS_PKG.PER_GET_NET_ACCRUAL(ASS.ASSIGNMENT_ID
, TRUNC(SYSDATE)
, PAP.ACCRUAL_PLAN_ID
, NULL)
, PER_VIEWS_PKG.PER_GET_ACCRUAL(ASS.ASSIGNMENT_ID
, TRUNC(SYSDATE)
, PAP.ACCRUAL_PLAN_ID
, NULL) ) ACCRUAL_VALUE
, HR_BIS.BIS_DECODE_LOOKUP('HOURS_OR_DAYS'
, PAP.ACCRUAL_UNITS_OF_MEASURE) ACCRUAL_UNITS
, ASS.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, DECODE( DUMMY.TYPE
, 1
, HR_BIS.BIS_DECODE_LOOKUP( 'NAME_TRANSLATIONS'
, 'PTO_NET_ENTITLEMENT' )
, HR_BIS.BIS_DECODE_LOOKUP( 'NAME_TRANSLATIONS'
, 'PTO_ACCRUED' ) ) ACCRUAL_COMPONENT
, DECODE( DUMMY.TYPE
, 1
, 3
, 2 ) ORDER_NUMBER
, PAP.ACCRUAL_PLAN_ID ACCRUAL_PLAN_ID
, PEE.ASSIGNMENT_ID ASSIGNMENT_ID
, ASS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM (SELECT 1 TYPE
FROM DUAL UNION SELECT 2 TYPE
FROM DUAL ) DUMMY
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PEOPLE_X PEO
, PER_ASSIGNMENTS_X ASS
, PAY_ELEMENT_ENTRIES_X PEE
, PAY_ELEMENT_LINKS_X PEL
, PAY_ELEMENT_TYPES_X PET
, PAY_ACCRUAL_PLANS PAP
WHERE PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PET.ELEMENT_TYPE_ID = PEL.ELEMENT_TYPE_ID
AND PEL.ELEMENT_LINK_ID = PEE.ELEMENT_LINK_ID
AND PEE.ASSIGNMENT_ID = ASS.ASSIGNMENT_ID
AND ASS.PERSON_ID = PEO.PERSON_ID
AND TRUNC(SYSDATE) >= (SELECT MIN(PTP2.START_DATE)
FROM PER_TIME_PERIODS PTP2
WHERE PTP2.PAYROLL_ID = ASS.PAYROLL_ID
AND PTP2.START_DATE >= (SELECT MIN(PEE1.EFFECTIVE_START_DATE)
FROM PAY_ELEMENT_ENTRIES_F PEE1
WHERE PEE1.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID))
AND ASS.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ASS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ASS.BUSINESS_GROUP_ID) UNION SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PAP.ACCRUAL_PLAN_NAME ACCRUAL_PLAN_NAME
, DECODE( PET1.ELEMENT_NAME
, PAP.ACCRUAL_PLAN_NAME || ' ' || HR_BIS.BIS_DECODE_LOOKUP( 'NAME_TRANSLATIONS'
, 'PTO_CO' )
, PER_VIEWS_PKG.PER_GET_ELEMENT_ACCRUAL(ASS.ASSIGNMENT_ID
, TRUNC(SYSDATE)
, PIV1.INPUT_VALUE_ID
, PAP.ACCRUAL_PLAN_ID
, PAP.ACCRUAL_CATEGORY )
, PER_VIEWS_PKG.PER_GET_ELEMENT_ACCRUAL(ASS.ASSIGNMENT_ID
, TRUNC(SYSDATE)
, PIV1.INPUT_VALUE_ID
, PAP.ACCRUAL_PLAN_ID
, PAP.ACCRUAL_CATEGORY ) * -1 ) ACCRUAL_VALUE
, HR_BIS.BIS_DECODE_LOOKUP('HOURS_OR_DAYS'
, PAP.ACCRUAL_UNITS_OF_MEASURE) ACCRUAL_UNITS
, ASS.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, DECODE( PET1.ELEMENT_NAME
, PAP.ACCRUAL_PLAN_NAME || ' ' || HR_BIS.BIS_DECODE_LOOKUP( 'NAME_TRANSLATIONS'
, 'PTO_CO' )
, HR_BIS.BIS_DECODE_LOOKUP( 'NAME_TRANSLATIONS'
, 'PTO_CO' )
, HR_BIS.BIS_DECODE_LOOKUP( 'NAME_TRANSLATIONS'
, 'PTO_TAKEN' ) ) ACCRUAL_COMPONENT
, 1 ORDER_NUMBER
, PAP.ACCRUAL_PLAN_ID ACCRUAL_PLAN_ID
, PEE.ASSIGNMENT_ID ASSIGNMENT_ID
, ASS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PEOPLE_X PEO
, PER_ASSIGNMENTS_X ASS
, PAY_INPUT_VALUES_X PIV1
, PAY_ELEMENT_TYPES_X PET1
, PAY_ELEMENT_ENTRIES_X PEE
, PAY_NET_CALCULATION_RULES NCR1
, PAY_ELEMENT_LINKS_X PEL
, PAY_ELEMENT_TYPES_X PET
, PAY_ACCRUAL_PLANS PAP1
, PAY_ACCRUAL_PLANS PAP
WHERE PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PET.ELEMENT_TYPE_ID = PEL.ELEMENT_TYPE_ID
AND PEL.ELEMENT_LINK_ID = PEE.ELEMENT_LINK_ID
AND PEE.ASSIGNMENT_ID = ASS.ASSIGNMENT_ID
AND ASS.PERSON_ID = PEO.PERSON_ID
AND TRUNC(SYSDATE) >= (SELECT MIN(PTP2.START_DATE)
FROM PER_TIME_PERIODS PTP2
WHERE PTP2.PAYROLL_ID = ASS.PAYROLL_ID
AND PTP2.START_DATE >= (SELECT MIN(PEE1.EFFECTIVE_START_DATE)
FROM PAY_ELEMENT_ENTRIES_F PEE1
WHERE PEE1.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID ))
AND PET1.EFFECTIVE_START_DATE = (SELECT MAX(PET2.EFFECTIVE_START_DATE)
FROM PAY_ELEMENT_TYPES_F PET2
WHERE PET2.EFFECTIVE_START_DATE <= TRUNC(SYSDATE)
AND PET2.ELEMENT_TYPE_ID = PET1.ELEMENT_TYPE_ID )
AND PET1.ELEMENT_TYPE_ID = PIV1.ELEMENT_TYPE_ID
AND PIV1.EFFECTIVE_START_DATE = (SELECT MAX(PIV2.EFFECTIVE_START_DATE)
FROM PAY_INPUT_VALUES_F PIV2
WHERE PIV2.EFFECTIVE_START_DATE <= TRUNC(SYSDATE)
AND PIV2.INPUT_VALUE_ID = PIV1.INPUT_VALUE_ID )
AND NCR1.INPUT_VALUE_ID = PIV1.INPUT_VALUE_ID
AND PAP1.ACCRUAL_PLAN_ID = NCR1.ACCRUAL_PLAN_ID
AND PAP.ACCRUAL_PLAN_ID = PAP1.ACCRUAL_PLAN_ID
AND ASS.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ASS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ASS.BUSINESS_GROUP_ID) WITH READ ONLY

Columns