APPS.PAY_WAT_UDFS dependencies on PAY_ELEMENT_ENTRIES_F

Line 9: FROM pay_element_entries_f PEE

5: l_subprio number(9);
6: BEGIN
7: SELECT nvl(pee.subpriority, 1)
8: INTO l_subprio
9: FROM pay_element_entries_f PEE
10: WHERE PEE.element_entry_id = p_ele_entry_id
11: AND p_date_earned
12: BETWEEN PEE.effective_start_date
13: AND PEE.effective_end_date;

Line 27: pay_element_entries_f PEE

23: SELECT pet.element_information1
24: INTO l_cat
25: FROM pay_element_types_f pet,
26: pay_element_links_f pel,
27: pay_element_entries_f PEE
28: WHERE PEE.element_entry_id = p_ele_entry_id
29: AND p_date_earned
30: BETWEEN PEE.effective_start_date
31: AND PEE.effective_end_date

Line 266: FROM pay_element_entries_f ee

262: IF ld_garn_date is NULL
263: THEN
264: SELECT MIN(effective_start_date)
265: INTO ld_garn_date
266: FROM pay_element_entries_f ee
267: WHERE ee.element_entry_id = p_element_entry_id;
268: hr_utility.trace(lv_mod_name || ': Min. Effective Start Date');
269: hr_utility.trace(lv_mod_name || ': '
270: || to_char(ld_garn_date, 'dd-mon-yyyy'));