APPS.PAY_SE_ALECTA dependencies on HR_GENERAL

Line 1113: SELECT hr_general.decode_lookup ('SE_AGREEMENT_PLAN'

1109: lr_new_joinee csr_new_joinee%ROWTYPE;
1110:
1111: CURSOR csr_agreement_plan (csr_v_assignment_id NUMBER)
1112: IS
1113: SELECT hr_general.decode_lookup ('SE_AGREEMENT_PLAN'
1114: ,aei_information1
1115: ) "AGREEMENT"
1116: FROM per_assignment_extra_info
1117: WHERE assignment_id = csr_v_assignment_id

Line 2562: SELECT hr_general.decode_lookup ('SE_ALECTA_COST_CENTER'

2558: lr_legal_employer_details csr_legal_employer_details%ROWTYPE;
2559:
2560: CURSOR csr_cost_center_details (csr_v_location_id NUMBER)
2561: IS
2562: SELECT hr_general.decode_lookup ('SE_ALECTA_COST_CENTER'
2563: ,lei_information1
2564: ) "COST_CENTER"
2565: FROM hr_location_extra_info
2566: WHERE location_id = csr_v_location_id