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.PER_PERIODS_OF_SERVICE_PKG dependencies on PER_ASSIGNMENTS

Line 10: from per_assignments pa

6: procedure delete_per_pay_proposals(p_period_of_service_id number
7: ,p_actual_termination_date date) is
8: --
9: cursor ass1 is select pa.assignment_id
10: from per_assignments pa
11: where pa.period_of_service_id = p_period_of_service_id;
12: --
13: -- VT #464380 05/14/97
14: cursor ppr1 (p_assignment_id_in number) is

Line 107: from per_assignments pa

103: --
104: begin
105: select count(distinct(payroll_id))
106: into p_no_payrolls
107: from per_assignments pa
108: where pa.period_of_service_id = p_period_of_service_id
109: and pa.person_id = p_person_id;
110: --
111: --

Line 119: from per_assignments pa

115: from per_time_periods
116: where p_actual_termination_date between
117: start_date and end_date
118: and payroll_id in (select payroll_id
119: from per_assignments pa
120: where pa.period_of_service_id = p_period_of_service_id
121: and pa.person_id = p_person_id);
122: --
123: --