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_COIDA_ARCHIVE dependencies on PER_PERSON_TYPE_USAGES_F

Line 373: , per_person_type_usages_f pptu

369: , asg.assignment_id
370: FROM
371: per_assignment_extra_info paei
372: , per_all_assignments_f asg
373: , per_person_type_usages_f pptu
374: , per_person_types ppt
375: WHERE
376: asg.payroll_id = l_payroll_id
377: AND asg.effective_end_date =

Line 832: per_person_type_usages_f pptu

828:
829: Select ppt.system_person_type
830: into l_person_type
831: from
832: per_person_type_usages_f pptu
833: , per_person_types ppt
834: Where p_date BETWEEN pptu.effective_start_date and pptu.effective_end_date
835: AND pptu.person_id = p_person_id
836: AND pptu.person_type_id = ppt.person_type_id

Line 1043: , per_person_type_usages_f pptu

1039: from per_all_people_f per
1040: , per_all_assignments_f asg
1041: , pay_assignment_actions paa
1042: , per_assignment_extra_info paei
1043: , per_person_type_usages_f pptu
1044: , per_person_types ppt
1045: where paa.assignment_action_id = p_assactid
1046: and asg.assignment_id = paa.assignment_id
1047: and per.person_id = asg.person_id