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

Line 178: FROM per_all_assignments_f asl

174: ,c_endperson NUMBER
175: ,c_payroll_id NUMBER
176: ) IS
177: SELECT assignment_id
178: FROM per_all_assignments_f asl
179: ,per_periods_of_service ppos
180: ,pay_payroll_actions ppa
181: WHERE ppa.payroll_action_id = c_pact_id
182: AND asl.person_id BETWEEN c_stperson AND c_endperson

Line 249: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

245: p_effective_date in date) IS
246:
247:
248: l_person_id per_all_people_f.person_id%TYPE;
249: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
250: l_end_date DATE;
251:
252: BEGIN
253:

Line 362: ,per_all_assignments_f paa

358: ,hoi.org_information1 company_name
359: ,paas.payroll_action_id
360: FROM per_all_people_F pap
361: ,per_periods_of_service ppf
362: ,per_all_assignments_f paa
363: ,pay_assignment_actions paas
364: ,hr_soft_coding_keyflex hr
365: ,hr_organization_information hoi
366: WHERE paas.assignment_action_id = p_assactid