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

Line 17: per_all_assignments_f asg,

13: begin
14: --
15: sqlstr := 'select distinct asg.person_id
16: from
17: per_all_assignments_f asg,
18: pay_payroll_actions pa1
19: where pa1.payroll_action_id = :payroll_action_id
20: and asg.business_group_id = pa1.business_group_id
21: order by asg.person_id';

Line 42: per_all_assignments_f paf,

38: cp_endperson number
39: ) is
40: select distinct paf.assignment_id
41: from per_periods_of_service pos,
42: per_all_assignments_f paf,
43: pay_payroll_actions ppa
44: where ppa.payroll_action_id = cp_pactid
45: and ppa.business_group_id = paf.business_group_id
46: and pos.period_of_service_id = paf.period_of_service_id

Line 96: , per_all_assignments_f paf

92: is
93: select paf.assignment_id
94: , paf.business_group_id
95: from pay_temp_object_actions toa
96: , per_all_assignments_f paf
97: where toa.object_action_id = p_ass_act_id
98: and toa.object_type = 'ASG'
99: and toa.object_id = paf.assignment_id
100: and p_eff_date between paf.effective_start_date