DBA Data[Home] [Help]

APPS.PAY_SE_ALECTA dependencies on HR_GENERAL

Line 1160: SELECT hr_general.decode_lookup ('SE_AGREEMENT_PLAN'

1156: lr_new_joinee csr_new_joinee%ROWTYPE;
1157:
1158: CURSOR csr_agreement_plan (csr_v_assignment_id NUMBER)
1159: IS
1160: SELECT hr_general.decode_lookup ('SE_AGREEMENT_PLAN'
1161: ,aei_information1
1162: ) "AGREEMENT"
1163: FROM per_assignment_extra_info
1164: WHERE assignment_id = csr_v_assignment_id

Line 1171: SELECT hr_general.decode_lookup ('SE_ALECTA_ITP_DETAILS'

1167: -- Start Changes 2008/2009
1168:
1169: CURSOR csr_alecta_itp_details (csr_v_assignment_id NUMBER)
1170: IS
1171: SELECT hr_general.decode_lookup ('SE_ALECTA_ITP_DETAILS'
1172: ,aei_information2
1173: )
1174: FROM per_assignment_extra_info
1175: WHERE assignment_id = csr_v_assignment_id

Line 2990: SELECT hr_general.decode_lookup ('SE_ALECTA_COST_CENTER'

2986: lr_legal_employer_details csr_legal_employer_details%ROWTYPE;
2987:
2988: CURSOR csr_cost_center_details (csr_v_location_id NUMBER)
2989: IS
2990: SELECT hr_general.decode_lookup ('SE_ALECTA_COST_CENTER'
2991: ,lei_information1
2992: ) "COST_CENTER"
2993: FROM hr_location_extra_info
2994: WHERE location_id = csr_v_location_id