APPS.PAY_DK_SICKPAY_PKG dependencies on PAY_INPUT_VALUES_F

Line 43: ,pay_input_values_f iv

39: FROM per_all_assignments_f asg
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

Line 186: ,pay_input_values_f iv1

182: ,per_all_assignments_f asg2
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

Line 212: eename pay_input_values_f.name%TYPE );

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;
215: l_tab l_table;
216:

Line 402: ,pay_input_values_f iv

398: FROM per_all_assignments_f asg
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