The following lines contain the word 'select', 'insert', 'update' or 'delete':
FOR x IN (SELECT meaning
FROM pv_lookups
WHERE lookup_code = p_lookup_code AND
lookup_type = p_lookup_type)
LOOP
l_meaning := x.meaning;
FOR x IN (SELECT meaning
FROM as_lookups
WHERE lookup_code = p_lookup_code AND
lookup_type = p_lookup_type)
LOOP
l_meaning := x.meaning;
FOR x IN (SELECT meaning
FROM ar_lookups
WHERE lookup_code = p_lookup_code AND
lookup_type = p_lookup_type)
LOOP
l_meaning := x.meaning;
FOR x IN (SELECT meaning
FROM fnd_lookup_values
WHERE lookup_code = p_lookup_code AND
lookup_type = p_lookup_type AND
LANGUAGE(+) = USERENV('LANG'))
LOOP
l_meaning := x.meaning;
FOR x IN (SELECT meaning
FROM as_statuses_tl
WHERE status_code = p_status_code AND
language = USERENV('LANG'))
LOOP
l_meaning := x.meaning;
FOR x IN (SELECT sales_channel meaning
FROM aso_i_sales_channels_v
WHERE sales_channel_code = p_sales_channel_code)
LOOP
l_meaning := x.meaning;
FOR x IN (SELECT name meaning
FROM as_sales_methodology_vl
WHERE sales_methodology_id = p_sales_methodology_id)
LOOP
l_meaning := x.meaning;
FOR x IN (SELECT name meaning
FROM as_sales_stages_all_vl
WHERE sales_stage_id = p_sales_stage_id)
LOOP
l_meaning := x.meaning;
FOR x IN (SELECT meaning
FROM as_sales_lead_ranks_vl
WHERE rank_id = p_rank_id)
LOOP
l_meaning := x.meaning;
FOR x IN (SELECT territory_short_name meaning
FROM fnd_territories_tl
WHERE territory_code = p_territory_code AND
language = USERENV('LANG'))
LOOP
l_meaning := x.meaning;
FOR x IN (SELECT country meaning
FROM hz_locations a,
hz_party_sites b
WHERE b.party_site_id = p_party_site_id AND
a.location_id = b.location_id)
LOOP
l_meaning := x.meaning;
FOR x IN (SELECT PERSON_LAST_NAME || ' ' || PERSON_FIRST_NAME meaning
FROM hz_relationships a,
hz_parties b
WHERE a.party_id = p_party_id AND
a.subject_type = 'PERSON' AND
a.subject_id = b.party_id)
LOOP
l_meaning := x.meaning;
FOR x IN (SELECT email_address meaning
FROM hz_relationships a,
hz_parties b
WHERE a.party_id = p_party_id AND
a.subject_type = 'PERSON' AND
a.subject_id = b.party_id)
LOOP
l_meaning := x.meaning;
FOR x IN (SELECT PHONE_COUNTRY_CODE || PHONE_AREA_CODE || PHONE_NUMBER ||
PHONE_EXTENSION meaning
FROM hz_contact_points
WHERE owner_table_name = 'HZ_PARTIES' AND
owner_table_id = p_party_id AND
contact_point_type = 'PHONE' AND
primary_flag = 'Y' AND
status = 'A')
LOOP
l_meaning := x.meaning;
FOR x IN (SELECT PERSON_LAST_NAME || ' ' || PERSON_FIRST_NAME meaning
FROM hz_relationships a,
hz_parties b,
as_lead_contacts_all aslc
WHERE aslc.lead_id = p_lead_id AND
aslc.primary_contact_flag = 'Y' AND
a.party_id = aslc.contact_party_id AND
a.subject_type = 'PERSON' AND
a.subject_id = b.party_id)
LOOP
l_meaning := x.meaning;
FOR x IN (SELECT email_address meaning
FROM hz_relationships a,
hz_parties b,
as_lead_contacts_all aslc
WHERE aslc.lead_id = p_lead_id AND
aslc.primary_contact_flag = 'Y' AND
a.party_id = aslc.contact_party_id AND
a.subject_type = 'PERSON' AND
a.subject_id = b.party_id)
LOOP
l_meaning := x.meaning;
FOR x IN (SELECT PHONE_COUNTRY_CODE || PHONE_AREA_CODE || PHONE_NUMBER ||
PHONE_EXTENSION meaning
FROM hz_contact_points,
as_lead_contacts_all aslc
WHERE aslc.lead_id = p_lead_id AND
aslc.primary_contact_flag = 'Y' AND
owner_table_name = 'HZ_PARTIES' AND
owner_table_id = aslc.contact_party_id AND
contact_point_type = 'PHONE')
LOOP
l_meaning := x.meaning;
FOR x IN (SELECT ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS_LABEL(
Null,
CUSTOMER_ADDRESS1,
CUSTOMER_ADDRESS2,
CUSTOMER_ADDRESS3,
CUSTOMER_ADDRESS4,
CUSTOMER_CITY,
CUSTOMER_COUNTY,
CUSTOMER_STATE,
CUSTOMER_PROVINCE,
CUSTOMER_POSTAL_CODE,
null,
CUSTOMER_COUNTRY,
Null,
Null,
Null,
Null,
Null,
NULL,
NULL,
NULL,
2000,
1,
1) ADDRESS
FROM pv_referrals_b
WHERE referral_id = p_referral_id)
LOOP
l_formatted_address := x.address;
FOR x IN (SELECT ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS_LABEL(
Null,
a.ADDRESS1,
a.ADDRESS2,
a.ADDRESS3,
a.ADDRESS4,
a.CITY,
a.COUNTY,
a.STATE,
a.PROVINCE,
a.POSTAL_CODE,
null,
a.COUNTRY,
Null,
Null,
Null,
Null,
Null,
NULL,
NULL,
NULL,
2000,
1,
1) ADDRESS
FROM hz_locations a,
hz_party_sites b
WHERE b.party_site_id = p_party_site_id AND
a.location_id = b.location_id AND
b.status = 'A')
LOOP
l_formatted_address := x.address;
FOR x IN (SELECT ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS_LABEL(
Null,
ADDRESS1,
ADDRESS2,
ADDRESS3,
ADDRESS4,
CITY,
COUNTY,
STATE,
PROVINCE,
POSTAL_CODE,
null,
COUNTRY,
Null,
Null,
Null,
Null,
Null,
NULL,
NULL,
NULL,
2000,
1,
1) ADDRESS
FROM hz_locations
WHERE location_id = p_location_id)
LOOP
l_formatted_address := x.address;
FOR x IN (SELECT source_name
FROM jtf_rs_resource_extns
WHERE resource_id = p_resource_id)
LOOP
l_source_name := x.source_name;
for x in ( select 1 exist_flag
from jtf_auth_principal_maps jtfpm,
jtf_auth_principals_b jtfp1,
jtf_auth_domains_b jtfd,
jtf_auth_principals_b jtfp2,
jtf_auth_role_perms jtfrp,
jtf_auth_permissions_b jtfperm,
fnd_user FU
where jtfp1.principal_name = FU.USER_NAME and
FU.CUSTOMER_ID = p_contact_rel_party_id and
jtfp1.is_user_flag=1
and jtfp1.jtf_auth_principal_id=jtfpm.jtf_auth_principal_id
and jtfpm.jtf_auth_parent_principal_id = jtfp2.jtf_auth_principal_id
and jtfp2.is_user_flag=0
and jtfp2.jtf_auth_principal_id = jtfrp.jtf_auth_principal_id
and jtfrp.positive_flag = 1
and jtfrp.jtf_auth_permission_id = jtfperm.jtf_auth_permission_id
and jtfperm.permission_name = p_permission
and jtfd.jtf_auth_domain_id=jtfpm.jtf_auth_domain_id
and jtfd.domain_name='CRM_DOMAIN')
loop
l_exists_flag := x.exist_flag;