APPS.OZF_RESALE_COMMON_PVT dependencies on HZ_CUST_ACCOUNTS

Line 415: FROM hz_cust_accounts hca

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

Line 428: FROM hz_cust_accounts hca

424: AND orsl.direct_customer_flag = 'T'
425: AND orsl.resale_batch_id = p_resale_batch_id
426: AND orsl.ship_from_cust_account_id IS NOT NULL
427: AND NOT EXISTS ( SELECT 1
428: FROM hz_cust_accounts hca
429: WHERE hca.cust_account_id = orsl.ship_from_cust_account_id)
430: UNION ALL
431: SELECT orsl.resale_line_int_id
432: , 'OZF_RESALE_UOM_NOT_IN_DB'

Line 2288: FROM hz_cust_accounts hca

2284: CURSOR count_cust_acctid_csr(p_id NUMBER) IS
2285: SELECT 1
2286: FROM dual
2287: WHERE EXISTS (SELECT hca.cust_account_id
2288: FROM hz_cust_accounts hca
2289: WHERE hca.cust_account_id = p_id);
2290: --
2291: BEGIN
2292:

Line 4073: FROM hz_cust_accounts

4069: l_sales_transaction_rec OZF_SALES_TRANSACTIONS_PVT.SALES_TRANSACTION_REC_TYPE;
4070:
4071: CURSOR party_id_csr(p_cust_account_id NUMBER) IS
4072: SELECT party_id
4073: FROM hz_cust_accounts
4074: WHERE cust_account_id = p_cust_account_id;
4075:
4076: CURSOR party_site_id_csr(p_account_site_id NUMBER) IS
4077: SELECT party_site_id