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 106: from per_assignments pa

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

Line 118: from per_assignments pa

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