APPS.ONT_OIP_COMMON dependencies on HZ_CUST_ACCOUNTS

Line 224: hz_cust_accounts cust

220: cust.cust_account_id CustomerId,
221: 0 CustomerAddrID
222: FROM fnd_user fnd,
223: hz_parties party,
224: hz_cust_accounts cust
225: WHERE fnd.customer_id = party.party_id
226: AND party.party_type = 'PERSON'
227: AND party.status = 'A'
228: AND cust.party_id = party.party_id

Line 337: hz_cust_accounts cust

333: Nvl(NULL,0)
334: FROM
335: fnd_user fnd,
336: hz_parties party,
337: hz_cust_accounts cust
338: WHERE fnd.customer_id = party.party_id
339: AND party.party_type='PERSON'
340: AND party.status = 'A'
341: AND cust.party_id=party.party_id

Line 407: from hz_cust_accounts cst,

403: gUserEmail,
404: gCustName ,
405: gCustomerID,
406: gCustomerAddrID
407: from hz_cust_accounts cst,
408: hz_parties cust_party,
409: hz_cust_account_roles con,
410: hz_parties party,
411: hz_parties rel_party,

Line 413: hz_cust_accounts acct

409: hz_cust_account_roles con,
410: hz_parties party,
411: hz_parties rel_party,
412: hz_relationships rel,
413: hz_cust_accounts acct
414: where
415: cst.cust_account_id = con.cust_account_id
416: and con.cust_account_role_id = gContactID
417: and rownum = 1