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

Line 1232: lv_last_name per_all_people_f.last_name%type;

1228: ld_effective_date DATE;
1229:
1230: ln_action_number NUMBER;
1231: ln_tax_unit_id NUMBER;
1232: lv_last_name per_all_people_f.last_name%type;
1233: lv_first_name per_all_people_f.first_name%type;
1234: lv_middle_name per_all_people_f.middle_names%type;
1235: lv_employee_number per_all_people_f.employee_number%type;
1236: lv_assignment_number per_all_assignments_f.assignment_number%type;

Line 1233: lv_first_name per_all_people_f.first_name%type;

1229:
1230: ln_action_number NUMBER;
1231: ln_tax_unit_id NUMBER;
1232: lv_last_name per_all_people_f.last_name%type;
1233: lv_first_name per_all_people_f.first_name%type;
1234: lv_middle_name per_all_people_f.middle_names%type;
1235: lv_employee_number per_all_people_f.employee_number%type;
1236: lv_assignment_number per_all_assignments_f.assignment_number%type;
1237: lv_national_identifier per_all_people_f.national_identifier%type;

Line 1234: lv_middle_name per_all_people_f.middle_names%type;

1230: ln_action_number NUMBER;
1231: ln_tax_unit_id NUMBER;
1232: lv_last_name per_all_people_f.last_name%type;
1233: lv_first_name per_all_people_f.first_name%type;
1234: lv_middle_name per_all_people_f.middle_names%type;
1235: lv_employee_number per_all_people_f.employee_number%type;
1236: lv_assignment_number per_all_assignments_f.assignment_number%type;
1237: lv_national_identifier per_all_people_f.national_identifier%type;
1238: lv_address_line pay_us_employee_action_info_v.address_line%type;

Line 1235: lv_employee_number per_all_people_f.employee_number%type;

1231: ln_tax_unit_id NUMBER;
1232: lv_last_name per_all_people_f.last_name%type;
1233: lv_first_name per_all_people_f.first_name%type;
1234: lv_middle_name per_all_people_f.middle_names%type;
1235: lv_employee_number per_all_people_f.employee_number%type;
1236: lv_assignment_number per_all_assignments_f.assignment_number%type;
1237: lv_national_identifier per_all_people_f.national_identifier%type;
1238: lv_address_line pay_us_employee_action_info_v.address_line%type;
1239:

Line 1237: lv_national_identifier per_all_people_f.national_identifier%type;

1233: lv_first_name per_all_people_f.first_name%type;
1234: lv_middle_name per_all_people_f.middle_names%type;
1235: lv_employee_number per_all_people_f.employee_number%type;
1236: lv_assignment_number per_all_assignments_f.assignment_number%type;
1237: lv_national_identifier per_all_people_f.national_identifier%type;
1238: lv_address_line pay_us_employee_action_info_v.address_line%type;
1239:
1240: lv_town_or_city varchar2(150);
1241: lv_county varchar2(150);