APPS.PQP_TIAALOD_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 38: l_org_ppg hr_organization_information.org_information1%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;
39: l_err_msg VARCHAR2(800);
40: l_err_num VARCHAR2(800);
41: l_chunk_no number;
42: l_ld_payroll_id pay_payroll_actions.payroll_id%TYPE;

Line 54: TYPE r_org_ppg IS RECORD (org_ppg_code hr_organization_information.org_information1%TYPE,

50: TYPE t_pay_mode IS TABLE OF r_pay_mode INDEX BY BINARY_INTEGER;
51:
52: pay_mode_t t_pay_mode;
53:
54: TYPE r_org_ppg IS RECORD (org_ppg_code hr_organization_information.org_information1%TYPE,
55: tax_unit_id pay_assignment_actions.tax_unit_id%TYPE);
56:
57: TYPE t_org_ppg IS TABLE OF r_org_ppg INDEX BY BINARY_INTEGER;
58: org_ppg_t t_org_ppg;

Line 67: org_ppg hr_organization_information.org_information1%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,
71: effective_date DATE,

Line 723: FROM hr_organization_information

719: PROCEDURE load_org_ppg(p_tax_unit_id IN NUMBER) IS
720:
721: CURSOR c_org_ppg IS
722: SELECT org_information1
723: FROM hr_organization_information
724: WHERE org_information_context = 'PQP_US_TIAA_CREF_CODES'
725: AND organization_id = p_tax_unit_id;
726: ltaxunit_id hr_organization_units.organization_id%TYPE := NULL;
727: BEGIN