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_ASSIGNMENT_EXTRA_INFO

Line 34: l_asg_ppg_code per_assignment_extra_info.aei_information1%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;
38: l_org_ppg hr_organization_information.org_information1%TYPE;

Line 66: asg_ppg_code per_assignment_extra_info.aei_information1%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,
70: org_name hr_organization_units.name%TYPE,

Line 625: FROM per_assignment_extra_info paei ,

621: PROCEDURE load_asg_ppg(p_assignment IN NUMBER) IS
622: CURSOR asg_ppg IS
623: SELECT paei.aei_information1,
624: pasg.payroll_id
625: FROM per_assignment_extra_info paei ,
626: per_assignments_f pasg
627: WHERE pasg.assignment_id = p_assignment
628: AND pasg.assignment_id = paei.assignment_id(+)
629: AND paei.information_type(+) = 'PQP_US_TIAA_CREF_CODES'