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 189: ,pay_element_entries_f ee

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

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

208: AND p_effective_date BETWEEN ee.effective_start_date AND ee.effective_end_date
209: AND p_effective_date BETWEEN eev1.effective_start_date AND eev1.effective_end_date
210: 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) ;
211: --
212: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
213: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
214: eename pay_input_values_f.name%TYPE );
215: l_rec l_record;
216: TYPE l_table is table of l_record index by BINARY_INTEGER;

Line 405: ,pay_element_entries_f ee

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