[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select roles.cust_account_role_id,
party.person_first_name,
party.person_last_name,
party.email_address,
party.party_name,
roles.cust_account_id,
nvl(roles.cust_acct_site_id,0)
from fnd_user fnd,
hz_parties party,
hz_cust_account_roles roles
where fnd.customer_id = party.party_id
and party.party_type='PARTY_RELATIONSHIP'
and party.party_id = roles.party_id
and roles.status ='A'
and party.status='A'
and fnd.user_id=lUserID;
select party.person_first_name,
party.person_last_name,
rel_party.email_address,
cust_party.party_name,
cst.cust_account_id,
nvl(con.cust_acct_site_id,0)
INTO gUserFName,
gUserLName,
gUserEmail,
gCustName ,
gCustomerID,
gCustomerAddrID
from hz_cust_accounts cst,
hz_parties cust_party,
hz_cust_account_roles con,
hz_parties party,
hz_parties rel_party,
hz_relationships rel,
hz_cust_accounts acct
where
cst.cust_account_id = con.cust_account_id
and con.cust_account_role_id = gContactID
and rownum = 1
and cst.party_id = cust_party.party_id
and con.party_id = rel.party_id
and con.role_type = 'CONTACT'
and rel.subject_id = party.party_id
and rel.subject_table_name = 'HZ_PARTIES'
and rel.object_table_name = 'HZ_PARTIES'
and rel.object_id = acct.party_id
and acct.cust_account_id = con.cust_account_id
and rel.party_id = rel_party.party_id;
SELECT meaning
INTO l_released_status_name
FROM wsh_lookups
WHERE lookup_type = 'PICK_STATUS'
AND lookup_code = 'I';
SELECT meaning
INTO l_released_status_name
FROM wsh_lookups
WHERE lookup_type = 'PICK_STATUS'
AND lookup_code = 'K';
SELECT meaning
INTO l_released_status_name
FROM wsh_lookups
WHERE lookup_type = 'PICK_STATUS'
AND lookup_code = p_released_status;
select To_Char(p_price*decode(p_line_category_code,'RETURN',-1,1),l_format_mask)
into x_price_formatted
from dual;