DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on HZ_CUST_ACCOUNTS

Line 705: FROM hz_cust_accounts

701: --Cursor to check Account Id
702: CURSOR c_account(p_account_id in number,
703: p_party_id in number) IS
704: SELECT cust_account_id
705: FROM hz_cust_accounts
706: WHERE cust_account_id = p_account_id
707: AND party_id = p_party_id
708: AND nvl(status, 'A') = 'A';
709:

Line 14942: hz_cust_accounts hza

14938: FROM cs_incidents_all_b inc,
14939: CS_INCIDENT_TYPES intp,
14940: CS_BUSINESS_PROCESSES bp,
14941: hz_parties hzp,
14942: hz_cust_accounts hza
14943: WHERE inc.incident_id = p_incident_id
14944: AND inc.incident_type_id = intp.incident_type_id
14945: AND intp.business_process_id = bp.business_process_id
14946: AND inc.customer_id = hzp.party_id

Line 16686: HZ_CUST_ACCOUNTS acct,

16682: CURSOR order_csr IS
16683: SELECT header_id,
16684: open_flag
16685: FROM OE_ORDER_HEADERS_ALL ooha,
16686: HZ_CUST_ACCOUNTS acct,
16687: HZ_PARTIES hp
16688: WHERE ooha.sold_to_org_id = acct.cust_account_id
16689: AND acct.party_id = hp.party_id
16690: AND ooha.header_id = p_order_header_id