DBA Data[Home] [Help]

APPS.HR_US_FF_UDF1 dependencies on PAY_ELEMENT_ENTRIES_F

Line 1362: pay_element_entries_f pee,

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,
1366: pay_input_values_f piv2

Line 1399: ,pay_element_entries_f pee

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
1402: ,pay_element_entry_values_f peev
1403: where pec.classification_name in

Line 2583: pay_element_entries_f pee,

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,
2587: pay_input_values_f piv2,

Line 2699: pay_element_entries_f pee,

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,
2703: pay_input_values_f piv2,

Line 2748: ,pay_element_entries_f pee

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
2751: ,pay_element_entry_values_f peev
2752: WHERE pec.classification_name in

Line 5379: pay_element_entries_f pee,

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,
5383: pay_input_values_f piv2,

Line 5951: pay_element_entries_f pee,

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,
5955: pay_input_values_f piv2