APPS.OZF_TP_ACCRUAL_PVT dependencies on HZ_CUST_ACCOUNTS

Line 594: FROM hz_cust_accounts

590: l_vol_offr_apply_discount NUMBER;
591:
592: CURSOR party_id_csr(p_cust_account_id IN NUMBER) IS
593: SELECT party_id
594: FROM hz_cust_accounts
595: WHERE cust_account_id = p_cust_account_id;
596:
597: CURSOR party_site_id_csr(p_account_site_id number) is
598: SELECT party_site_id

Line 4701: FROM hz_cust_accounts hca

4697: -- bug # 7375849 fixed by ateotia (+)
4698: --, substr(hp.party_name, 1,30)
4699: , hp.party_name
4700: -- bug # 7375849 fixed by ateotia (-)
4701: FROM hz_cust_accounts hca
4702: , hz_parties hp
4703: WHERE hca.cust_account_id = p_id
4704: AND hca.party_id = hp.party_id;
4705: