DBA Data[Home] [Help]

APPS.PAY_SE_ALECTA dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1116: FROM per_assignment_extra_info

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
1118: AND information_type = 'SE_ALECTA_DETAILS';
1119:
1120: CURSOR csr_get_joining_date (csr_v_assignment_id NUMBER)