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_CONTACT_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 22: , per_all_assignments_f paf

18: , aei.aei_information1
19: , aei.aei_information2
20: , aei.aei_information3
21: FROM per_assignment_extra_info aei
22: , per_all_assignments_f paf
23: WHERE aei.assignment_id = p_asg_id
24: AND aei.information_type = 'PAYROLL_CONTACT'
25: AND aei.aei_information_category = 'PAYROLL_CONTACT'
26: AND paf.assignment_id = aei.assignment_id

Line 68: from per_all_assignments_f paf

64: , p_phone
65: , p_email
66: from dual
67: where not exists (select 1
68: from per_all_assignments_f paf
69: , per_assignment_extra_info aei
70: where paf.assignment_id = aei.assignment_id
71: and paf.business_group_id = p_business_group_id
72: and paf.assignment_id = p_assignment_id