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_TYPES

Line 374: , per_person_types ppt

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 =
378: ( SELECT

Line 679: l_person_type per_person_types.system_person_type%type;

675: l_run_action_seq number;
676: l_run_assact_id number;
677: l_start_py_adv_dt date;
678: l_pay_adv_start_date date;
679: l_person_type per_person_types.system_person_type%type;
680:
681: -- Bug # 12329847 and 12334564
682:
683: l_start_date date;

Line 833: , per_person_types ppt

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
837: AND ppt.system_person_type in ('EMP','EX_EMP');

Line 1044: , per_person_types ppt

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
1048: and paei.assignment_id = asg.assignment_id