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.PQP_TIAALOD_PKG dependencies on PER_ALL_PEOPLE_F

Line 30: l_last_name per_all_people_f.last_name%TYPE;

26: t_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
27: l_defined_balance_id NUMBER;
28: l_row_count NUMBER :=0;
29: l_national_id per_people_v.national_identifier%TYPE;
30: l_last_name per_all_people_f.last_name%TYPE;
31: l_first_name per_all_people_f.first_name%TYPE;
32: l_middle_name per_all_people_f.middle_names%TYPE;
33: l_dob per_all_people_f.date_of_birth%TYPE;
34: l_asg_ppg_code per_assignment_extra_info.aei_information1%TYPE;

Line 31: l_first_name per_all_people_f.first_name%TYPE;

27: l_defined_balance_id NUMBER;
28: l_row_count NUMBER :=0;
29: l_national_id per_people_v.national_identifier%TYPE;
30: l_last_name per_all_people_f.last_name%TYPE;
31: l_first_name per_all_people_f.first_name%TYPE;
32: l_middle_name per_all_people_f.middle_names%TYPE;
33: l_dob per_all_people_f.date_of_birth%TYPE;
34: l_asg_ppg_code per_assignment_extra_info.aei_information1%TYPE;
35: l_pay_mode pay_payrolls_f.prl_information4%TYPE;

Line 32: l_middle_name per_all_people_f.middle_names%TYPE;

28: l_row_count NUMBER :=0;
29: l_national_id per_people_v.national_identifier%TYPE;
30: l_last_name per_all_people_f.last_name%TYPE;
31: l_first_name per_all_people_f.first_name%TYPE;
32: l_middle_name per_all_people_f.middle_names%TYPE;
33: l_dob per_all_people_f.date_of_birth%TYPE;
34: l_asg_ppg_code per_assignment_extra_info.aei_information1%TYPE;
35: l_pay_mode pay_payrolls_f.prl_information4%TYPE;
36: l_ppg_billing pay_payrolls_f.prl_information7%TYPE;

Line 33: l_dob per_all_people_f.date_of_birth%TYPE;

29: l_national_id per_people_v.national_identifier%TYPE;
30: l_last_name per_all_people_f.last_name%TYPE;
31: l_first_name per_all_people_f.first_name%TYPE;
32: l_middle_name per_all_people_f.middle_names%TYPE;
33: l_dob per_all_people_f.date_of_birth%TYPE;
34: l_asg_ppg_code per_assignment_extra_info.aei_information1%TYPE;
35: l_pay_mode pay_payrolls_f.prl_information4%TYPE;
36: l_ppg_billing pay_payrolls_f.prl_information7%TYPE;
37: l_payroll_id per_assignments_f.payroll_id%TYPE;

Line 61: (last_name per_all_people_f.last_name%TYPE,

57: TYPE t_org_ppg IS TABLE OF r_org_ppg INDEX BY BINARY_INTEGER;
58: org_ppg_t t_org_ppg;
59:
60: TYPE r_ins_val IS RECORD
61: (last_name per_all_people_f.last_name%TYPE,
62: first_name per_all_people_f.first_name%TYPE,
63: middle_name per_all_people_f.middle_names%TYPE,
64: dob per_all_people_f.date_of_birth%TYPE,
65: national_id per_all_people_f.national_identifier%TYPE,

Line 62: first_name per_all_people_f.first_name%TYPE,

58: org_ppg_t t_org_ppg;
59:
60: TYPE r_ins_val IS RECORD
61: (last_name per_all_people_f.last_name%TYPE,
62: first_name per_all_people_f.first_name%TYPE,
63: middle_name per_all_people_f.middle_names%TYPE,
64: dob per_all_people_f.date_of_birth%TYPE,
65: national_id per_all_people_f.national_identifier%TYPE,
66: asg_ppg_code per_assignment_extra_info.aei_information1%TYPE,

Line 63: middle_name per_all_people_f.middle_names%TYPE,

59:
60: TYPE r_ins_val IS RECORD
61: (last_name per_all_people_f.last_name%TYPE,
62: first_name per_all_people_f.first_name%TYPE,
63: middle_name per_all_people_f.middle_names%TYPE,
64: dob per_all_people_f.date_of_birth%TYPE,
65: national_id per_all_people_f.national_identifier%TYPE,
66: asg_ppg_code per_assignment_extra_info.aei_information1%TYPE,
67: org_ppg hr_organization_information.org_information1%TYPE,

Line 64: dob per_all_people_f.date_of_birth%TYPE,

60: TYPE r_ins_val IS RECORD
61: (last_name per_all_people_f.last_name%TYPE,
62: first_name per_all_people_f.first_name%TYPE,
63: middle_name per_all_people_f.middle_names%TYPE,
64: dob per_all_people_f.date_of_birth%TYPE,
65: national_id per_all_people_f.national_identifier%TYPE,
66: asg_ppg_code per_assignment_extra_info.aei_information1%TYPE,
67: org_ppg hr_organization_information.org_information1%TYPE,
68: pay_mode pay_payrolls_f.prl_information4%TYPE,

Line 65: national_id per_all_people_f.national_identifier%TYPE,

61: (last_name per_all_people_f.last_name%TYPE,
62: first_name per_all_people_f.first_name%TYPE,
63: middle_name per_all_people_f.middle_names%TYPE,
64: dob per_all_people_f.date_of_birth%TYPE,
65: national_id per_all_people_f.national_identifier%TYPE,
66: asg_ppg_code per_assignment_extra_info.aei_information1%TYPE,
67: org_ppg hr_organization_information.org_information1%TYPE,
68: pay_mode pay_payrolls_f.prl_information4%TYPE,
69: gre_name hr_organization_units.name%TYPE,

Line 660: FROM per_all_people_f ppv,

656: ppv.first_name,
657: ppv.middle_names,
658: ppv.date_of_birth,
659: ppv.national_identifier
660: FROM per_all_people_f ppv,
661: per_assignments_f paf
662: WHERE paf.assignment_id = p_assignment
663: AND paf.person_id = ppv.person_id
664: AND l_actual_date BETWEEN ppv.effective_start_date