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.

APPS.HR_US_FF_UDF1 dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1360: from pay_element_entry_values_f pev1,

1356: Cursor Vertex_EE_Cursor is
1357: select pev1.element_entry_id,
1358: pev1.screen_entry_value Jurisdiction_code,
1359: pev2.screen_entry_value Percentage
1360: from pay_element_entry_values_f pev1,
1361: pay_element_entry_values_f pev2,
1362: pay_element_entries_f pee,
1363: pay_element_links_f pel,
1364: pay_element_types_f pet,

Line 1361: pay_element_entry_values_f pev2,

1357: select pev1.element_entry_id,
1358: pev1.screen_entry_value Jurisdiction_code,
1359: pev2.screen_entry_value Percentage
1360: from pay_element_entry_values_f pev1,
1361: pay_element_entry_values_f pev2,
1362: pay_element_entries_f pee,
1363: pay_element_links_f pel,
1364: pay_element_types_f pet,
1365: pay_input_values_f piv1,

Line 1402: ,pay_element_entry_values_f peev

1398: ,pay_element_types_f pet
1399: ,pay_element_entries_f pee
1400: ,pay_element_links_f pel
1401: ,pay_input_values_f piv
1402: ,pay_element_entry_values_f peev
1403: where pec.classification_name in
1404: ( 'Earnings', 'Supplemental Earnings','Imputed Earnings' )
1405: and pet.classification_id = pec.classification_id
1406: and pee.effective_start_date between pet.effective_start_date

Line 2581: FROM pay_element_entry_values_f pev1,

2577: p_assignment_id IN NUMBER,
2578: p_date_earned IN DATE) IS
2579: SELECT pev1.screen_entry_value Jurisdiction,
2580: SUM(pev2.screen_entry_value) Hours
2581: FROM pay_element_entry_values_f pev1,
2582: pay_element_entry_values_f pev2,
2583: pay_element_entries_f pee,
2584: pay_element_links_f pel,
2585: pay_element_types_f pet,

Line 2582: pay_element_entry_values_f pev2,

2578: p_date_earned IN DATE) IS
2579: SELECT pev1.screen_entry_value Jurisdiction,
2580: SUM(pev2.screen_entry_value) Hours
2581: FROM pay_element_entry_values_f pev1,
2582: pay_element_entry_values_f pev2,
2583: pay_element_entries_f pee,
2584: pay_element_links_f pel,
2585: pay_element_types_f pet,
2586: pay_input_values_f piv1,

Line 2697: FROM pay_element_entry_values_f pev1,

2693: p_assignment_id IN NUMBER,
2694: p_date_earned IN DATE) IS
2695: SELECT pev1.screen_entry_value Jurisdiction,
2696: SUM(pev2.screen_entry_value) Hours
2697: FROM pay_element_entry_values_f pev1,
2698: pay_element_entry_values_f pev2,
2699: pay_element_entries_f pee,
2700: pay_element_links_f pel,
2701: pay_element_types_f pet,

Line 2698: pay_element_entry_values_f pev2,

2694: p_date_earned IN DATE) IS
2695: SELECT pev1.screen_entry_value Jurisdiction,
2696: SUM(pev2.screen_entry_value) Hours
2697: FROM pay_element_entry_values_f pev1,
2698: pay_element_entry_values_f pev2,
2699: pay_element_entries_f pee,
2700: pay_element_links_f pel,
2701: pay_element_types_f pet,
2702: pay_input_values_f piv1,

Line 2751: ,pay_element_entry_values_f peev

2747: ,pay_element_types_f pet
2748: ,pay_element_entries_f pee
2749: ,pay_element_links_f pel
2750: ,pay_input_values_f piv
2751: ,pay_element_entry_values_f peev
2752: WHERE pec.classification_name in
2753: ( 'Earnings', 'Supplemental Earnings','Imputed Earnings' )
2754: AND pec.legislation_code = 'US'
2755: AND pet.classification_id = pec.classification_id

Line 5377: FROM pay_element_entry_values_f pev1,

5373: p_effective_date IN DATE,
5374: p_jurisdiction_code IN VARCHAR2,
5375: p_jd_level IN NUMBER) IS
5376: SELECT SUM(pev2.screen_entry_value) Hours
5377: FROM pay_element_entry_values_f pev1,
5378: pay_element_entry_values_f pev2,
5379: pay_element_entries_f pee,
5380: pay_element_links_f pel,
5381: pay_element_types_f pet,

Line 5378: pay_element_entry_values_f pev2,

5374: p_jurisdiction_code IN VARCHAR2,
5375: p_jd_level IN NUMBER) IS
5376: SELECT SUM(pev2.screen_entry_value) Hours
5377: FROM pay_element_entry_values_f pev1,
5378: pay_element_entry_values_f pev2,
5379: pay_element_entries_f pee,
5380: pay_element_links_f pel,
5381: pay_element_types_f pet,
5382: pay_input_values_f piv1,

Line 5949: from pay_element_entry_values_f pev1,

5945: pev1.screen_entry_value Jurisdiction_code,
5946: pev2.screen_entry_value Percentage,
5947: least(last_day(p_date_earned),pee.effective_end_date)
5948: -greatest(pee.effective_start_date,trunc(p_date_earned,'MONTH') )+1 days
5949: from pay_element_entry_values_f pev1,
5950: pay_element_entry_values_f pev2,
5951: pay_element_entries_f pee,
5952: pay_element_links_f pel,
5953: pay_element_types_f pet,

Line 5950: pay_element_entry_values_f pev2,

5946: pev2.screen_entry_value Percentage,
5947: least(last_day(p_date_earned),pee.effective_end_date)
5948: -greatest(pee.effective_start_date,trunc(p_date_earned,'MONTH') )+1 days
5949: from pay_element_entry_values_f pev1,
5950: pay_element_entry_values_f pev2,
5951: pay_element_entries_f pee,
5952: pay_element_links_f pel,
5953: pay_element_types_f pet,
5954: pay_input_values_f piv1,