APPS.HR_US_FF_UDF1 dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1319: from pay_element_entry_values_f pev1,

1315: Cursor Vertex_EE_Cursor is
1316: select pev1.element_entry_id,
1317: pev1.screen_entry_value Jurisdiction_code,
1318: pev2.screen_entry_value Percentage
1319: from pay_element_entry_values_f pev1,
1320: pay_element_entry_values_f pev2,
1321: pay_element_entries_f pee,
1322: pay_element_links_f pel,
1323: pay_element_types_f pet,

Line 1320: pay_element_entry_values_f pev2,

1316: select pev1.element_entry_id,
1317: pev1.screen_entry_value Jurisdiction_code,
1318: pev2.screen_entry_value Percentage
1319: from pay_element_entry_values_f pev1,
1320: pay_element_entry_values_f pev2,
1321: pay_element_entries_f pee,
1322: pay_element_links_f pel,
1323: pay_element_types_f pet,
1324: pay_input_values_f piv1,

Line 1361: ,pay_element_entry_values_f peev

1357: ,pay_element_types_f pet
1358: ,pay_element_entries_f pee
1359: ,pay_element_links_f pel
1360: ,pay_input_values_f piv
1361: ,pay_element_entry_values_f peev
1362: where pec.classification_name in
1363: ( 'Earnings', 'Supplemental Earnings','Imputed Earnings' )
1364: and pet.classification_id = pec.classification_id
1365: and pee.effective_start_date between pet.effective_start_date

Line 2482: FROM pay_element_entry_values_f pev1,

2478: p_assignment_id IN NUMBER,
2479: p_date_earned IN DATE) IS
2480: SELECT pev1.screen_entry_value Jurisdiction,
2481: SUM(pev2.screen_entry_value) Hours
2482: FROM pay_element_entry_values_f pev1,
2483: pay_element_entry_values_f pev2,
2484: pay_element_entries_f pee,
2485: pay_element_links_f pel,
2486: pay_element_types_f pet,

Line 2483: pay_element_entry_values_f pev2,

2479: p_date_earned IN DATE) IS
2480: SELECT pev1.screen_entry_value Jurisdiction,
2481: SUM(pev2.screen_entry_value) Hours
2482: FROM pay_element_entry_values_f pev1,
2483: pay_element_entry_values_f pev2,
2484: pay_element_entries_f pee,
2485: pay_element_links_f pel,
2486: pay_element_types_f pet,
2487: pay_input_values_f piv1,

Line 2598: FROM pay_element_entry_values_f pev1,

2594: p_assignment_id IN NUMBER,
2595: p_date_earned IN DATE) IS
2596: SELECT pev1.screen_entry_value Jurisdiction,
2597: SUM(pev2.screen_entry_value) Hours
2598: FROM pay_element_entry_values_f pev1,
2599: pay_element_entry_values_f pev2,
2600: pay_element_entries_f pee,
2601: pay_element_links_f pel,
2602: pay_element_types_f pet,

Line 2599: pay_element_entry_values_f pev2,

2595: p_date_earned IN DATE) IS
2596: SELECT pev1.screen_entry_value Jurisdiction,
2597: SUM(pev2.screen_entry_value) Hours
2598: FROM pay_element_entry_values_f pev1,
2599: pay_element_entry_values_f pev2,
2600: pay_element_entries_f pee,
2601: pay_element_links_f pel,
2602: pay_element_types_f pet,
2603: pay_input_values_f piv1,

Line 2652: ,pay_element_entry_values_f peev

2648: ,pay_element_types_f pet
2649: ,pay_element_entries_f pee
2650: ,pay_element_links_f pel
2651: ,pay_input_values_f piv
2652: ,pay_element_entry_values_f peev
2653: WHERE pec.classification_name in
2654: ( 'Earnings', 'Supplemental Earnings','Imputed Earnings' )
2655: AND pec.legislation_code = 'US'
2656: AND pet.classification_id = pec.classification_id

Line 5190: FROM pay_element_entry_values_f pev1,

5186: p_effective_date IN DATE,
5187: p_jurisdiction_code IN VARCHAR2,
5188: p_jd_level IN NUMBER) IS
5189: SELECT SUM(pev2.screen_entry_value) Hours
5190: FROM pay_element_entry_values_f pev1,
5191: pay_element_entry_values_f pev2,
5192: pay_element_entries_f pee,
5193: pay_element_links_f pel,
5194: pay_element_types_f pet,

Line 5191: pay_element_entry_values_f pev2,

5187: p_jurisdiction_code IN VARCHAR2,
5188: p_jd_level IN NUMBER) IS
5189: SELECT SUM(pev2.screen_entry_value) Hours
5190: FROM pay_element_entry_values_f pev1,
5191: pay_element_entry_values_f pev2,
5192: pay_element_entries_f pee,
5193: pay_element_links_f pel,
5194: pay_element_types_f pet,
5195: pay_input_values_f piv1,