eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HRFV_ACCRUAL_PLAN_ENROLLMENTS

Source

View Text - Preformatted


SELECT bgrt.name business_group_name ,peo.full_name person_name ,pap.accrual_plan_name accrual_plan_name ,hr_bis.bis_decode_lookup('US_PTO_ACCRUAL', pap.accrual_category) accrual_category ,hr_bis.bis_decode_lookup('US_ACCRUAL_START_TYPE',pap.accrual_start) accrual_start_rule ,hr_bis.bis_decode_lookup('HOURS_OR_DAYS', pap.accrual_units_of_measure) accrual_units ,pee.effective_start_date effective_start_date ,hr_discoverer.check_end_date(pee.effective_end_date) effective_end_date ,peo.employee_number employee_number ,NVL(fnd_date.canonical_to_date(pev.screen_entry_value), pps.date_start) continuous_service_date ,pab.annual_rate annual_rate ,ass.assignment_number assignment_number ,orgt.name organization_name ,jbt.name job_name ,pft.name position_name ,gdt.name grade_name ,loct.location_code location_name ,pay.payroll_name payroll_name ,pap.accrual_plan_id accrual_plan_id ,pee.assignment_id assignment_id ,pap.business_group_id business_group_id ,pee.element_entry_id element_entry_id ,gdt.grade_id grade_id ,jbt.job_id job_id ,ass.payroll_id payroll_id ,ass.person_id person_id ,pft.position_id position_id FROM per_people_x peo ,hr_all_organization_units_tl orgt ,hr_all_organization_units_tl bgrt ,per_jobs_tl jbt ,hr_all_positions_f_tl pft ,per_grades_tl gdt ,hr_locations_all_tl loct ,pay_payrolls_x pay ,per_periods_of_service pps ,per_assignments_x ass ,pay_element_entries_x pee ,pay_element_links_x pel ,pay_element_entry_values_x pev ,pay_element_types_x pet ,pay_input_values_x piv ,pay_accrual_bands pab ,pay_accrual_plans pap WHERE pap.accrual_plan_element_type_id = pet.element_type_id AND pee.assignment_id = ass.assignment_id AND pel.element_link_id = pee.element_link_id AND pet.element_type_id = pel.element_type_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 pap.accrual_plan_element_type_id = piv.element_type_id AND piv.display_sequence = 1 AND piv.name <> 'Pay Value' AND piv.input_value_id = pev.input_value_id AND pev.element_entry_id = pee.element_entry_id AND ass.period_of_service_id = pps.period_of_service_id AND pap.accrual_plan_id = pab.accrual_plan_id AND (TRUNC(ABS(MONTHS_BETWEEN(NVL( fnd_date.canonical_to_date( decode(substr(piv.uom, 1, 1) , 'D', pev.screen_entry_value , null)) , pps.date_start),TRUNC(sysdate))))/12) BETWEEN pab.lower_limit AND pab.upper_limit AND ass.person_id = peo.person_id AND ass.organization_id = orgT.organization_id AND orgt.language = userenv('LANG') AND ass.job_id = jbt.job_id(+) AND jbt.language (+) = userenv('LANG') AND ass.position_id = pft.position_id(+) AND pft.language (+) = userenv('LANG') AND ass.grade_id = gdt.grade_id(+) AND gdt.language (+) = userenv('LANG') AND ass.location_id = locT.location_id(+) AND loct.language (+) = userenv('LANG') AND ass.payroll_id = pay.payroll_id AND ass.business_group_id = bgrT.organization_id AND bgrt.language = userenv('LANG') AND pap.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,pap.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PAP.ACCRUAL_PLAN_NAME ACCRUAL_PLAN_NAME
, HR_BIS.BIS_DECODE_LOOKUP('US_PTO_ACCRUAL'
, PAP.ACCRUAL_CATEGORY) ACCRUAL_CATEGORY
, HR_BIS.BIS_DECODE_LOOKUP('US_ACCRUAL_START_TYPE'
, PAP.ACCRUAL_START) ACCRUAL_START_RULE
, HR_BIS.BIS_DECODE_LOOKUP('HOURS_OR_DAYS'
, PAP.ACCRUAL_UNITS_OF_MEASURE) ACCRUAL_UNITS
, PEE.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, HR_DISCOVERER.CHECK_END_DATE(PEE.EFFECTIVE_END_DATE) EFFECTIVE_END_DATE
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, NVL(FND_DATE.CANONICAL_TO_DATE(PEV.SCREEN_ENTRY_VALUE)
, PPS.DATE_START) CONTINUOUS_SERVICE_DATE
, PAB.ANNUAL_RATE ANNUAL_RATE
, ASS.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, ORGT.NAME ORGANIZATION_NAME
, JBT.NAME JOB_NAME
, PFT.NAME POSITION_NAME
, GDT.NAME GRADE_NAME
, LOCT.LOCATION_CODE LOCATION_NAME
, PAY.PAYROLL_NAME PAYROLL_NAME
, PAP.ACCRUAL_PLAN_ID ACCRUAL_PLAN_ID
, PEE.ASSIGNMENT_ID ASSIGNMENT_ID
, PAP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID ELEMENT_ENTRY_ID
, GDT.GRADE_ID GRADE_ID
, JBT.JOB_ID JOB_ID
, ASS.PAYROLL_ID PAYROLL_ID
, ASS.PERSON_ID PERSON_ID
, PFT.POSITION_ID POSITION_ID
FROM PER_PEOPLE_X PEO
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_JOBS_TL JBT
, HR_ALL_POSITIONS_F_TL PFT
, PER_GRADES_TL GDT
, HR_LOCATIONS_ALL_TL LOCT
, PAY_PAYROLLS_X PAY
, PER_PERIODS_OF_SERVICE PPS
, PER_ASSIGNMENTS_X ASS
, PAY_ELEMENT_ENTRIES_X PEE
, PAY_ELEMENT_LINKS_X PEL
, PAY_ELEMENT_ENTRY_VALUES_X PEV
, PAY_ELEMENT_TYPES_X PET
, PAY_INPUT_VALUES_X PIV
, PAY_ACCRUAL_BANDS PAB
, PAY_ACCRUAL_PLANS PAP
WHERE PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PEE.ASSIGNMENT_ID = ASS.ASSIGNMENT_ID
AND PEL.ELEMENT_LINK_ID = PEE.ELEMENT_LINK_ID
AND PET.ELEMENT_TYPE_ID = PEL.ELEMENT_TYPE_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 PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID
AND PIV.DISPLAY_SEQUENCE = 1
AND PIV.NAME <> 'PAY VALUE'
AND PIV.INPUT_VALUE_ID = PEV.INPUT_VALUE_ID
AND PEV.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND ASS.PERIOD_OF_SERVICE_ID = PPS.PERIOD_OF_SERVICE_ID
AND PAP.ACCRUAL_PLAN_ID = PAB.ACCRUAL_PLAN_ID
AND (TRUNC(ABS(MONTHS_BETWEEN(NVL( FND_DATE.CANONICAL_TO_DATE( DECODE(SUBSTR(PIV.UOM
, 1
, 1)
, 'D'
, PEV.SCREEN_ENTRY_VALUE
, NULL))
, PPS.DATE_START)
, TRUNC(SYSDATE))))/12) BETWEEN PAB.LOWER_LIMIT
AND PAB.UPPER_LIMIT
AND ASS.PERSON_ID = PEO.PERSON_ID
AND ASS.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND ASS.JOB_ID = JBT.JOB_ID(+)
AND JBT.LANGUAGE (+) = USERENV('LANG')
AND ASS.POSITION_ID = PFT.POSITION_ID(+)
AND PFT.LANGUAGE (+) = USERENV('LANG')
AND ASS.GRADE_ID = GDT.GRADE_ID(+)
AND GDT.LANGUAGE (+) = USERENV('LANG')
AND ASS.LOCATION_ID = LOCT.LOCATION_ID(+)
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND ASS.PAYROLL_ID = PAY.PAYROLL_ID
AND ASS.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PAP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PAP.BUSINESS_GROUP_ID) WITH READ ONLY