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

Line 459: FROM per_all_people_f

455: , order_name
456: , full_name
457: , middle_names
458: , title
459: FROM per_all_people_f
460: where person_id=p_person_id
461: and p_effective_date between effective_start_date and effective_end_date;
462:
463:

Line 481: , per_all_people_f ppf

477: , ppf.middle_names
478: , ppf.title
479: , paf.assignment_number
480: FROM per_all_assignments_f paf
481: , per_all_people_f ppf
482: , per_periods_of_service pps
483: , per_jobs pj
484: , hr_organization_units hou
485: , pay_payrolls_f prl

Line 618: l_first_name per_all_people_f.first_name%TYPE;

614: WHERE org_payment_method_id = p_opm_id
615: and p_effective_date between effective_start_date and effective_end_date;
616: --
617: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
618: l_first_name per_all_people_f.first_name%TYPE;
619: l_last_name per_all_people_f.last_name%TYPE;
620: l_order_name per_all_people_f.order_name%TYPE;
621: l_full_name per_all_people_f.full_name%TYPE;
622: l_national_identifier per_all_people_f.national_identifier%TYPE;

Line 619: l_last_name per_all_people_f.last_name%TYPE;

615: and p_effective_date between effective_start_date and effective_end_date;
616: --
617: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
618: l_first_name per_all_people_f.first_name%TYPE;
619: l_last_name per_all_people_f.last_name%TYPE;
620: l_order_name per_all_people_f.order_name%TYPE;
621: l_full_name per_all_people_f.full_name%TYPE;
622: l_national_identifier per_all_people_f.national_identifier%TYPE;
623: l_employee_number per_all_people_f.employee_number%TYPE;

Line 620: l_order_name per_all_people_f.order_name%TYPE;

616: --
617: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
618: l_first_name per_all_people_f.first_name%TYPE;
619: l_last_name per_all_people_f.last_name%TYPE;
620: l_order_name per_all_people_f.order_name%TYPE;
621: l_full_name per_all_people_f.full_name%TYPE;
622: l_national_identifier per_all_people_f.national_identifier%TYPE;
623: l_employee_number per_all_people_f.employee_number%TYPE;
624: l_middle_names per_all_people_f.middle_names%TYPE;

Line 621: l_full_name per_all_people_f.full_name%TYPE;

617: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
618: l_first_name per_all_people_f.first_name%TYPE;
619: l_last_name per_all_people_f.last_name%TYPE;
620: l_order_name per_all_people_f.order_name%TYPE;
621: l_full_name per_all_people_f.full_name%TYPE;
622: l_national_identifier per_all_people_f.national_identifier%TYPE;
623: l_employee_number per_all_people_f.employee_number%TYPE;
624: l_middle_names per_all_people_f.middle_names%TYPE;
625: l_title per_all_people_f.title%TYPE;

Line 622: l_national_identifier per_all_people_f.national_identifier%TYPE;

618: l_first_name per_all_people_f.first_name%TYPE;
619: l_last_name per_all_people_f.last_name%TYPE;
620: l_order_name per_all_people_f.order_name%TYPE;
621: l_full_name per_all_people_f.full_name%TYPE;
622: l_national_identifier per_all_people_f.national_identifier%TYPE;
623: l_employee_number per_all_people_f.employee_number%TYPE;
624: l_middle_names per_all_people_f.middle_names%TYPE;
625: l_title per_all_people_f.title%TYPE;
626: l_business_group_id number;

Line 623: l_employee_number per_all_people_f.employee_number%TYPE;

619: l_last_name per_all_people_f.last_name%TYPE;
620: l_order_name per_all_people_f.order_name%TYPE;
621: l_full_name per_all_people_f.full_name%TYPE;
622: l_national_identifier per_all_people_f.national_identifier%TYPE;
623: l_employee_number per_all_people_f.employee_number%TYPE;
624: l_middle_names per_all_people_f.middle_names%TYPE;
625: l_title per_all_people_f.title%TYPE;
626: l_business_group_id number;
627: l_per_pay_method number;

Line 624: l_middle_names per_all_people_f.middle_names%TYPE;

620: l_order_name per_all_people_f.order_name%TYPE;
621: l_full_name per_all_people_f.full_name%TYPE;
622: l_national_identifier per_all_people_f.national_identifier%TYPE;
623: l_employee_number per_all_people_f.employee_number%TYPE;
624: l_middle_names per_all_people_f.middle_names%TYPE;
625: l_title per_all_people_f.title%TYPE;
626: l_business_group_id number;
627: l_per_pay_method number;
628: l_pre_pay_id number;

Line 625: l_title per_all_people_f.title%TYPE;

621: l_full_name per_all_people_f.full_name%TYPE;
622: l_national_identifier per_all_people_f.national_identifier%TYPE;
623: l_employee_number per_all_people_f.employee_number%TYPE;
624: l_middle_names per_all_people_f.middle_names%TYPE;
625: l_title per_all_people_f.title%TYPE;
626: l_business_group_id number;
627: l_per_pay_method number;
628: l_pre_pay_id number;
629: l_prepay_asg_act number;