DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on HZ_CUST_ACCOUNTS

Line 686: FROM hz_cust_accounts

682: --Cursor to check Account Id
683: CURSOR c_account(p_account_id in number,
684: p_party_id in number) IS
685: SELECT cust_account_id
686: FROM hz_cust_accounts
687: WHERE cust_account_id = p_account_id
688: AND party_id = p_party_id
689: AND nvl(status, 'A') = 'A';
690:

Line 13405: hz_cust_accounts hza

13401: FROM cs_incidents_all_b inc,
13402: CS_INCIDENT_TYPES intp,
13403: CS_BUSINESS_PROCESSES bp,
13404: hz_parties hzp,
13405: hz_cust_accounts hza
13406: WHERE inc.incident_id = p_incident_id
13407: AND inc.incident_type_id = intp.incident_type_id
13408: AND intp.business_process_id = bp.business_process_id
13409: AND inc.customer_id = hzp.party_id

Line 15115: HZ_CUST_ACCOUNTS acct,

15111: CURSOR order_csr IS
15112: SELECT header_id,
15113: open_flag
15114: FROM OE_ORDER_HEADERS_ALL ooha,
15115: HZ_CUST_ACCOUNTS acct,
15116: HZ_PARTIES hp
15117: WHERE ooha.sold_to_org_id = acct.cust_account_id
15118: AND acct.party_id = hp.party_id
15119: AND ooha.header_id = p_order_header_id