DBA Data[Home] [Help]

APPS.PAY_DK_ABSENCE_USER dependencies on PAY_INPUT_VALUES_F

Line 67: ,pay_input_values_f pivf

63: SELECT
64: peef.element_entry_id
65: FROM
66: pay_element_entry_values_f peevf
67: ,pay_input_values_f pivf
68: ,pay_element_entries_f peef
69: WHERE
70: peevf.screen_entry_value = p_creator_id
71: AND pivf.input_value_id = peevf.input_value_id

Line 230: ,pay_input_values_f iv1

226: ,per_all_assignments_f asg2
227: ,per_all_people_f per
228: ,pay_element_links_f el
229: ,pay_element_types_f et
230: ,pay_input_values_f iv1
231: ,pay_element_entries_f ee
232: ,pay_element_entry_values_f eev1
233: WHERE asg1.assignment_id = p_assignment_id
234: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 260: eename pay_input_values_f.name%TYPE );

256: ORDER BY ee.element_entry_id;
257: --
258: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
259: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
260: eename pay_input_values_f.name%TYPE );
261: l_rec l_record;
262: TYPE l_table is table of l_record index by BINARY_INTEGER;
263: l_tab l_table;
264: l_start_date date;

Line 478: ,pay_input_values_f iv1

474: ,per_all_assignments_f asg2
475: ,per_all_people_f per
476: ,pay_element_links_f el
477: ,pay_element_types_f et
478: ,pay_input_values_f iv1
479: ,pay_element_entries_f ee
480: ,pay_element_entry_values_f eev1
481: WHERE asg1.assignment_id = p_assignment_id
482: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 507: eename pay_input_values_f.name%TYPE );

503: ORDER BY ee.element_entry_id;
504: --
505: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
506: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
507: eename pay_input_values_f.name%TYPE );
508: l_rec l_record;
509: TYPE l_table is table of l_record index by BINARY_INTEGER;
510: l_tab l_table;
511: l_start_date date;

Line 648: ,pay_input_values_f iv1

644: ,per_all_assignments_f asg2
645: ,per_all_people_f per
646: ,pay_element_links_f el
647: ,pay_element_types_f et
648: ,pay_input_values_f iv1
649: ,pay_element_entries_f ee
650: ,pay_element_entry_values_f eev1
651: WHERE asg1.assignment_id = p_assignment_id
652: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 677: eename pay_input_values_f.name%TYPE );

673: ORDER BY ee.element_entry_id;
674: --
675: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
676: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
677: eename pay_input_values_f.name%TYPE );
678: l_rec l_record;
679: TYPE l_table is table of l_record index by BINARY_INTEGER;
680: l_tab l_table;
681: l_start_date date;

Line 801: ,pay_input_values_f iv1

797: ,per_all_assignments_f asg2
798: ,per_all_people_f per
799: ,pay_element_links_f el
800: ,pay_element_types_f et
801: ,pay_input_values_f iv1
802: ,pay_element_entries_f ee
803: ,pay_element_entry_values_f eev1
804: WHERE asg1.assignment_id = p_assignment_id
805: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 830: eename pay_input_values_f.name%TYPE );

826: ORDER BY ee.element_entry_id;
827: --
828: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
829: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
830: eename pay_input_values_f.name%TYPE );
831: l_rec l_record;
832: TYPE l_table is table of l_record index by BINARY_INTEGER;
833: l_tab l_table;
834: l_start_date date;