The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NVL (lkup.meaning, per.person_title) ||
DECODE (per.person_first_name, NULL, NULL, ' ' ||
per.person_first_name) ||
DECODE (per.person_middle_name, NULL, NULL, ' ' ||
per.person_middle_name) ||
DECODE (per.person_last_name, NULL, NULL, ' ' ||
per.person_last_name) ||
DECODE (per.person_name_suffix, NULL, NULL, ' ' ||
per.person_name_suffix) person_name
FROM hz_parties per,
fnd_lookup_values lkup
WHERE per.party_id = cp_person_id
AND per.person_pre_name_adjunct = lkup.lookup_code (+)
AND lkup.lookup_type (+) = cp_lookup_type
AND lkup.language(+) = USERENV('LANG')
AND lkup.view_application_id(+) = cp_view_application_id
AND lkup.security_group_id(+) = cp_security_group_id;
SELECT addr.address1 ||
DECODE (addr.address2, NULL, NULL, l_line_break || addr.address2) ||
DECODE (addr.address3, NULL, NULL, l_line_break || addr.address3) ||
DECODE (addr.address4, NULL, NULL, l_line_break || addr.address4) ||
DECODE (addr.city, NULL, NULL, l_line_break || addr.city) ||
DECODE (addr.state, NULL, NULL, l_line_break || addr.state) ||
DECODE (addr.postal_code, NULL, NULL, ' ' || addr.postal_code) ||
DECODE (tr.territory_short_name, NULL, NULL, l_line_break ||
tr.territory_short_name) person_address
FROM hz_parties addr,
fnd_territories_vl tr
WHERE addr.party_id = cp_person_id
AND addr.country = tr.territory_code(+);
SELECT usg.form_left_prompt form_left_prompt,
usg.application_column_name application_column_name
FROM fnd_descr_flex_col_usage_vl usg
WHERE usg.descriptive_flexfield_name = 'IGS_AD_APPL_INST_FLEX'
AND usg.enabled_flag = 'Y'
AND usg.application_id = 8405;
EXECUTE IMMEDIATE ' SELECT '|| rec_cur_enabled_attributes.application_column_name||
' FROM igs_ad_ps_appl_inst_all '||
' WHERE person_id = :1' ||
' AND admission_appl_number = :2'||
' AND nominated_course_cd = :3' ||
' AND sequence_number = :4'
INTO l_column_value
USING p_person_id, p_admission_appl_number, p_nominated_course_cd, p_sequence_number;
SELECT usg.form_left_prompt form_left_prompt,
usg.application_column_name application_column_name
FROM fnd_descr_flex_col_usage_vl usg
WHERE usg.descriptive_flexfield_name = 'IGS_PE_PERS_RESIDENCY_FLEX'
AND usg.enabled_flag = 'Y'
AND usg.application_id = 8405;
EXECUTE IMMEDIATE ' SELECT ' || rec_cur_enabled_attributes.application_column_name ||
' FROM igs_pe_res_dtls_all '||
' WHERE resident_details_id = :1'
INTO l_column_value
USING p_resident_details_id;
SELECT peit.pei_information1 restatus_code, pecc.meaning restatus_desc
FROM igs_pe_eit peit,
igs_lookups_view pecc
WHERE peit.pei_information1 = pecc.lookup_code
AND peit.person_id = p_person_id
AND peit.start_date <= SYSDATE
AND NVL(peit.end_date,SYSDATE) >= SYSDATE
AND pecc.lookup_type='PE_CITI_STATUS'
AND ENABLED_FLAG = 'Y';