142: IS
143: SELECT PAA.ASSIGNMENT_ID
144: FROM per_all_assignments_f PAA
145: , per_all_people_f PAP
146: , hr_soft_coding_keyflex SCL
147: WHERE PAA.BUSINESS_GROUP_ID = p_business_group_id
148: AND PAP.per_information_category ='FI'
149: AND PAP.NATIONAL_IDENTIFIER = p_ni
150: AND PAA.PERSON_ID = PAP.PERSON_ID
183: IS
184: SELECT PAA.ASSIGNMENT_ID
185: FROM per_all_assignments_f PAA
186: , per_all_people_f PAP
187: , hr_soft_coding_keyflex SCL
188: WHERE PAA.BUSINESS_GROUP_ID = p_business_group_id
189: AND PAP.per_information_category ='FI'
190: AND PAP.NATIONAL_IDENTIFIER = p_ni
191: AND PAA.PERSON_ID = PAP.PERSON_ID