APPS.PQP_US_PENSION_EXTRACTS dependencies on HR_ORGANIZATION_INFORMATION

Line 1161: FROM hr_organization_information

1157: AND prl.effective_end_date;
1158:
1159: CURSOR csr_org_ppg (c_tax_unit_id IN NUMBER) IS
1160: SELECT org_information1 --PPG CODE
1161: FROM hr_organization_information
1162: WHERE org_information_context = 'PQP_US_TIAA_CREF_CODES'
1163: AND organization_id = c_tax_unit_id;
1164:
1165: CURSOR csr_gre_id (c_effective_date IN DATE