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_ZA_EMP201 dependencies on PER_ALL_PEOPLE_F

Line 419: from per_all_people_f ppf

415: , p_legal_entity_id number
416: , p_payroll_id number) is
417: select ppf.person_id
418: , paa.assignment_id
419: from per_all_people_f ppf
420: , per_all_assignments_f paa
421: , pay_payroll_actions ppa
422: , per_periods_of_service pps
423: , per_assignment_extra_info aei

Line 435: from per_all_people_f ppf1

431: and paa.payroll_id = nvl(p_payroll_id, paa.payroll_id)
432: and paa.period_of_service_id = pps.period_of_service_id
433: -- last person record before this month end
434: and ppf.effective_start_date = ( select max(effective_start_date)
435: from per_all_people_f ppf1
436: where ppf1.person_id = ppf.person_id
437: and ppf1.effective_start_date <= p_canonical_end_date
438: )
439: -- last assignment record before this month end

Line 627: from per_all_people_f p

623: ,a.assignment_id
624: ,a.period_of_service_id
625: ,a.assignment_number
626: ,a.payroll_id
627: from per_all_people_f p
628: , per_all_assignments_f a
629: , pay_assignment_actions paa
630: where paa.assignment_action_id = p_assactid
631: and a.assignment_id = paa.assignment_id