DBA Data[Home] [Help]

APPS.HR_US_FF_UDF1 dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 1397: from pay_element_classifications pec

1393: Cursor tagged_earnings_Cursor is
1394: select /*+ INDEX (paa pay_assignment_actions_n51) */ distinct
1395: peev.element_entry_id,
1396: peev.screen_entry_value
1397: from pay_element_classifications pec
1398: ,pay_element_types_f pet
1399: ,pay_element_entries_f pee
1400: ,pay_element_links_f pel
1401: ,pay_input_values_f piv

Line 2704: pay_element_classifications pec

2700: pay_element_links_f pel,
2701: pay_element_types_f pet,
2702: pay_input_values_f piv1,
2703: pay_input_values_f piv2,
2704: pay_element_classifications pec
2705: WHERE pec.classification_name IN ( 'Earnings', 'Supplemental Earnings','Imputed Earnings' )
2706: AND pec.legislation_code = 'US'
2707: AND pec.classification_id = pet.classification_id
2708: AND pet.element_type_id = pel.element_type_id

Line 2746: FROM pay_element_classifications pec

2742: IS
2743: SELECT /*+ INDEX (paa pay_assignment_actions_n51) */ DISTINCT
2744: peev.screen_entry_value Jurisdiction,
2745: 0 Hours
2746: FROM pay_element_classifications pec
2747: ,pay_element_types_f pet
2748: ,pay_element_entries_f pee
2749: ,pay_element_links_f pel
2750: ,pay_input_values_f piv