[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT account_name, account_number,cust_account_id, object_version_number
FROM hz_cust_accounts
WHERE party_id=p_party_id
AND ((status = 'A' AND l_account_status = 'Y') OR (l_account_status = 'N'))
AND status not in ('M', 'D')
ORDER BY creation_date ASC;
SELECT account_name, account_number,cust_account_id, object_version_number
FROM hz_cust_accounts
WHERE party_id=p_party_id
AND ((status = 'A' AND l_account_status = 'Y') OR (l_account_status = 'N'))
AND status not in ('M', 'D')
ORDER BY creation_date DESC;
SELECT ph.phone_country_code, ph.phone_area_code, ph.phone_number,
lkup.meaning, ph.phone_line_type,
ph.contact_point_id, ph.object_version_number, phone_extension,
ph.phone_country_code||ph.phone_area_code||ph.phone_number
INTO l_phone_country_code, l_phone_area_code, l_phone_number,
l_phone_line_type, l_phone_line_code,
l_phone_id, l_phone_object_version_number, l_phone_extension,
l_full_phone
FROM hz_contact_points ph, ar_lookups lkup
WHERE ph.phone_line_type = lkup.lookup_code
AND lkup.lookup_type = 'PHONE_LINE_TYPE'
AND lkup.enabled_flag = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(lkup.start_date_active, SYSDATE))
AND TRUNC(NVL(lkup.end_date_active,SYSDATE))
AND ph.owner_table_id = x_Phone_Rec(i).party_id
AND ph.owner_table_name = 'HZ_PARTIES'
AND ph.contact_point_type = 'PHONE'
AND ph.primary_flag = 'Y';
SELECT ph.phone_country_code ,
ph.phone_area_code ,
ph.phone_number ,
lkup.meaning ,
ph.phone_line_type ,
ph.contact_point_id ,
ph.object_version_number,
phone_extension ,
ph.phone_country_code||ph.phone_area_code||ph.phone_number
INTO l_phone_country_code ,
l_phone_area_code ,
l_phone_number ,
l_phone_line_type ,
l_phone_line_code ,
l_phone_id ,
l_phone_object_version_number,
l_phone_extension ,
l_full_phone
FROM hz_contact_points ph,
ar_lookups lkup ,
hz_party_sites ps
WHERE ph.phone_line_type = lkup.lookup_code
AND lkup.lookup_type = 'PHONE_LINE_TYPE'
AND lkup.enabled_flag = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(lkup.start_date_active, SYSDATE)) AND TRUNC(NVL(lkup.end_date_active,SYSDATE))
AND ph.owner_table_id = p_site_id(i)
AND ps.party_site_id = ph.owner_table_id
AND ps.party_id = x_Phone_Rec(i).party_id
AND ph.owner_table_name = 'HZ_PARTY_SITES'
AND ph.contact_point_type = 'PHONE';