APPS.PAY_DK_ABSENCE_USER dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 66: pay_element_entry_values_f peevf

62: CURSOR csr_get_intial_entry_id(p_creator_id IN VARCHAR2 ,p_assignment_id IN NUMBER ) IS
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

Line 232: ,pay_element_entry_values_f eev1

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
235: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
236: AND per.person_id = asg1.person_id

Line 259: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,

255: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
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;

Line 480: ,pay_element_entry_values_f eev1

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
483: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
484: AND per.person_id = asg1.person_id

Line 506: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,

502: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
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;

Line 650: ,pay_element_entry_values_f eev1

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
653: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
654: AND per.person_id = asg1.person_id

Line 676: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,

672: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
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;

Line 803: ,pay_element_entry_values_f eev1

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
806: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
807: AND per.person_id = asg1.person_id

Line 829: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,

825: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
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;