DBA Data[Home] [Help]

APPS.HR_US_FF_UDF1 dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 1356: from pay_element_classifications pec

1352: Cursor tagged_earnings_Cursor is
1353: select /*+ INDEX (paa pay_assignment_actions_n51) */ distinct
1354: peev.element_entry_id,
1355: peev.screen_entry_value
1356: from pay_element_classifications pec
1357: ,pay_element_types_f pet
1358: ,pay_element_entries_f pee
1359: ,pay_element_links_f pel
1360: ,pay_input_values_f piv

Line 2605: pay_element_classifications pec

2601: pay_element_links_f pel,
2602: pay_element_types_f pet,
2603: pay_input_values_f piv1,
2604: pay_input_values_f piv2,
2605: pay_element_classifications pec
2606: WHERE pec.classification_name IN ( 'Earnings', 'Supplemental Earnings','Imputed Earnings' )
2607: AND pec.legislation_code = 'US'
2608: AND pec.classification_id = pet.classification_id
2609: AND pet.element_type_id = pel.element_type_id

Line 2647: FROM pay_element_classifications pec

2643: IS
2644: SELECT /*+ INDEX (paa pay_assignment_actions_n51) */ DISTINCT
2645: peev.screen_entry_value Jurisdiction,
2646: 0 Hours
2647: FROM pay_element_classifications pec
2648: ,pay_element_types_f pet
2649: ,pay_element_entries_f pee
2650: ,pay_element_links_f pel
2651: ,pay_input_values_f piv