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_GENERAL dependencies on PAY_ELEMENT_ENTRIES_F

Line 25: ,pay_element_entries_f ee

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

Line 113: ,pay_element_entries_f ee

109: FROM per_all_assignments_f asg
110: ,per_all_people_f per
111: ,pay_element_links_f el
112: ,pay_element_types_f et
113: ,pay_element_entries_f ee
114: WHERE asg.assignment_id = p_assignment_id
115: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
116: AND et.element_name = 'Tax'
117: AND et.legislation_code = 'DK'

Line 184: ,pay_element_entries_f ee

180: FROM per_all_assignments_f asg
181: ,per_all_people_f per
182: ,pay_element_links_f el
183: ,pay_element_types_f et
184: ,pay_element_entries_f ee
185: WHERE asg.assignment_id = p_assignment_id
186: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
187: AND et.element_name = 'Employee ATP'
188: AND et.legislation_code = 'DK'

Line 268: ,pay_element_entries_f ee

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
272: AND per.person_id = asg1.person_id

Line 320: ,pay_element_entries_f ee

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

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

338: AND p_effective_date BETWEEN eev1.effective_start_date AND eev1.effective_end_date
339: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
340: ORDER BY ee.element_entry_id;
341: --
342: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
343: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
344: eename pay_input_values_f.name%TYPE );
345: l_rec l_record;
346: TYPE l_table is table of l_record index by BINARY_INTEGER;

Line 536: pay_element_entries_f peef

532:
533: CURSOR c_pen_entries_count
534: IS
535: select count(distinct element_entry_id) from
536: pay_element_entries_f peef
537: where
538: peef.element_type_id = p_element_type_id
539: and peef.assignment_id = p_assignment_id
540: AND p_effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date;

Line 546: pay_element_entries_f peef

542:
543: CURSOR c_pen_entries
544: IS
545: select distinct element_entry_id from
546: pay_element_entries_f peef
547: where
548: peef.element_type_id = p_element_type_id
549: and peef.assignment_id = p_assignment_id
550: AND p_effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date;