APPS.PAY_DK_SICKPAY_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 44: ,pay_element_entries_f ee

40: ,per_all_people_f per
41: ,pay_element_links_f el
42: ,pay_element_types_f et
43: ,pay_input_values_f iv
44: ,pay_element_entries_f ee
45: ,pay_element_entry_values_f eev
46: WHERE asg.assignment_id = p_assignment_id
47: AND per.person_id = asg.person_id
48: AND et.element_name IN ('Absent Sick','Absent Holiday')

Line 187: ,pay_element_entries_f ee

183: ,per_all_people_f per
184: ,pay_element_links_f el
185: ,pay_element_types_f et
186: ,pay_input_values_f iv1
187: ,pay_element_entries_f ee
188: ,pay_element_entry_values_f eev1
189: WHERE asg1.assignment_id = p_assignment_id
190: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
191: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 210: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,

206: AND p_effective_date BETWEEN ee.effective_start_date AND ee.effective_end_date
207: AND p_effective_date BETWEEN eev1.effective_start_date AND eev1.effective_end_date
208: ORDER BY ee.element_entry_id, DECODE(iv1.name, 'Start Date', 1,'End Date', 2, 'Sick Days', 3,'Start Time', 4,'End Time', 5,'Sick Hours', 6) ;
209: --
210: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
211: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
212: eename pay_input_values_f.name%TYPE );
213: l_rec l_record;
214: TYPE l_table is table of l_record index by BINARY_INTEGER;

Line 403: ,pay_element_entries_f ee

399: ,per_all_people_f per
400: ,pay_element_links_f el
401: ,pay_element_types_f et
402: ,pay_input_values_f iv
403: ,pay_element_entries_f ee
404: ,pay_element_entry_values_f eev
405: WHERE asg.assignment_id = p_assignment_id
406: AND per.person_id = asg.person_id
407: AND et.element_name IN ('Absent Sick','Absent Holiday')