DBA Data[Home] [Help]

APPS.PAY_DK_GENERAL dependencies on PAY_INPUT_VALUES_F

Line 24: ,pay_input_values_f iv1

20: ,per_all_assignments_f asg2
21: ,per_all_people_f per
22: ,pay_element_links_f el
23: ,pay_element_types_f et
24: ,pay_input_values_f iv1
25: ,pay_element_entries_f ee
26: ,pay_element_entry_values_f eev1
27: WHERE asg1.assignment_id = p_assignment_id
28: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 267: ,pay_input_values_f iv1

263: ,per_all_assignments_f asg2
264: ,per_all_people_f per
265: ,pay_element_links_f el
266: ,pay_element_types_f et
267: ,pay_input_values_f iv1
268: ,pay_element_entries_f ee
269: ,pay_element_entry_values_f eev1
270: WHERE asg1.assignment_id = p_assignment_id
271: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 319: ,pay_input_values_f iv1

315: ,per_all_assignments_f asg2
316: ,per_all_people_f per
317: ,pay_element_links_f el
318: ,pay_element_types_f et
319: ,pay_input_values_f iv1
320: ,pay_element_entries_f ee
321: ,pay_element_entry_values_f eev1
322: WHERE asg1.assignment_id = p_assignment_id
323: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 343: eename pay_input_values_f.name%TYPE );

339: ORDER BY ee.element_entry_id;
340: --
341: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
342: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
343: eename pay_input_values_f.name%TYPE );
344: l_rec l_record;
345: TYPE l_table is table of l_record index by BINARY_INTEGER;
346: l_tab l_table;
347: