150: ,c_effective_date IN DATE
151: ) Is
152: SELECT aei_information5,
153: aei_information6
154: FROM per_assignment_extra_info paei,
155: pay_element_types_f pet
156: WHERE assignment_id = c_assignment_id
157: AND information_type = 'PQP_US_SRS_PLAN_ASG_INFO'
158: AND aei_information4 = pet.element_name
179: ) Is
180: SELECT aei_information4,
181: aei_information5,
182: aei_information6
183: FROM per_assignment_extra_info paei
184: WHERE assignment_id = c_assignment_id
185: AND information_type = 'PQP_US_SRS_PLAN_ASG_INFO';
186:
187: l_aei_information4 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION4%TYPE;
183: FROM per_assignment_extra_info paei
184: WHERE assignment_id = c_assignment_id
185: AND information_type = 'PQP_US_SRS_PLAN_ASG_INFO';
186:
187: l_aei_information4 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION4%TYPE;
188: l_aei_information5 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION5%TYPE;
189: l_aei_information6 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION6%TYPE;
190: l_effective_date DATE;
191: l_srs_enrolled VARCHAR2(1) := 'N';
184: WHERE assignment_id = c_assignment_id
185: AND information_type = 'PQP_US_SRS_PLAN_ASG_INFO';
186:
187: l_aei_information4 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION4%TYPE;
188: l_aei_information5 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION5%TYPE;
189: l_aei_information6 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION6%TYPE;
190: l_effective_date DATE;
191: l_srs_enrolled VARCHAR2(1) := 'N';
192: l_ele_name pay_element_types_f.element_name%TYPE;
185: AND information_type = 'PQP_US_SRS_PLAN_ASG_INFO';
186:
187: l_aei_information4 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION4%TYPE;
188: l_aei_information5 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION5%TYPE;
189: l_aei_information6 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION6%TYPE;
190: l_effective_date DATE;
191: l_srs_enrolled VARCHAR2(1) := 'N';
192: l_ele_name pay_element_types_f.element_name%TYPE;
193: l_base_ele_id pay_element_types_f.element_type_id%TYPE;