APPS.PER_IE_ASG_EXT_INFO SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

SELECT DISTINCT NATIONAL_IDENTIFIER
FROM per_all_assignments_f paaf, per_all_people_f papf
WHERE paaf.assignment_id = P_ASSIGNMENT_ID
AND paaf.person_id = papf.person_id;

Line: 25

SELECT NVL(instr(substr(P_AEI_INFORMATION1,1,length(l_ppsn_number)),l_ppsn_number),0) check_ppsn
FROM dual;

Line: 48

PROCEDURE UPDATE_IE_ASG_EXT_INFO(P_ASSIGNMENT_EXTRA_INFO_ID  NUMBER
					,P_AEI_ATTRIBUTE_CATEGORY	VARCHAR2
					,P_AEI_INFORMATION_CATEGORY   VARCHAR2
					,P_AEI_INFORMATION1      VARCHAR2
					,P_AEI_INFORMATION2      VARCHAR2
					,P_AEI_INFORMATION3      VARCHAR2
					,P_AEI_INFORMATION4      VARCHAR2
					,P_AEI_INFORMATION5      VARCHAR2
					)
IS

CURSOR cur_ppsn_number IS
SELECT DISTINCT NATIONAL_IDENTIFIER
FROM per_all_assignments_f paaf, per_all_people_f papf, per_assignment_extra_info paei
WHERE paei.assignment_extra_info_id = p_assignment_extra_info_id
and paei.aei_information_category = p_aei_information_category
AND paaf.assignment_id = paei.assignment_id
AND paaf.person_id = papf.person_id;

Line: 70

SELECT NVL(instr(substr(P_AEI_INFORMATION1,1,length(l_ppsn_number)),l_ppsn_number),0) check_ppsn
FROM dual;