eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DK_ABSENCE_USER dependencies on PAY_ELEMENT_ENTRIES_F

Line 68: ,pay_element_entries_f peef

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
72: AND pivf.NAME = 'CREATOR_ID'

Line 231: ,pay_element_entries_f ee

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
235: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date

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

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

Line 479: ,pay_element_entries_f ee

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
483: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date

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

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

Line 649: ,pay_element_entries_f ee

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
653: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date

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

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

Line 802: ,pay_element_entries_f ee

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
806: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date

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

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