APPS.OZF_RESALE_COMMON_PVT dependencies on HZ_CUST_ACCOUNTS

Line 401: FROM hz_cust_accounts hca

397: AND orsl.direct_customer_flag = 'T'
398: AND orsl.resale_batch_id = p_resale_batch_id
399: AND orsl.sold_from_cust_account_id IS NOT NULL
400: AND NOT EXISTS ( SELECT 1
401: FROM hz_cust_accounts hca
402: WHERE hca.cust_account_id = orsl.sold_from_cust_account_id)
403: UNION ALL
404: SELECT orsl.resale_line_int_id
405: , 'OZF_CLAIM_CUST_NOT_IN_DB'

Line 414: FROM hz_cust_accounts hca

410: AND orsl.direct_customer_flag = 'T'
411: AND orsl.resale_batch_id = p_resale_batch_id
412: AND orsl.ship_from_cust_account_id IS NOT NULL
413: AND NOT EXISTS ( SELECT 1
414: FROM hz_cust_accounts hca
415: WHERE hca.cust_account_id = orsl.ship_from_cust_account_id)
416: UNION ALL
417: SELECT orsl.resale_line_int_id
418: , 'OZF_RESALE_UOM_NOT_IN_DB'

Line 1921: FROM hz_cust_accounts hca

1917: CURSOR count_cust_acctid_csr(p_id NUMBER) IS
1918: SELECT 1
1919: FROM dual
1920: WHERE EXISTS (SELECT hca.cust_account_id
1921: FROM hz_cust_accounts hca
1922: WHERE hca.cust_account_id = p_id);
1923: --
1924: BEGIN
1925:

Line 3302: FROM hz_cust_accounts

3298: l_sales_transaction_rec OZF_SALES_TRANSACTIONS_PVT.SALES_TRANSACTION_REC_TYPE;
3299:
3300: CURSOR party_id_csr(p_cust_account_id NUMBER) IS
3301: SELECT party_id
3302: FROM hz_cust_accounts
3303: WHERE cust_account_id = p_cust_account_id;
3304:
3305: CURSOR party_site_id_csr(p_account_site_id NUMBER) IS
3306: SELECT party_site_id