DBA Data[Home] [Help]

APPS.OZF_TP_ACCRUAL_PVT dependencies on HZ_CUST_ACCOUNTS

Line 548: FROM hz_cust_accounts

544: l_vol_offr_apply_discount NUMBER;
545:
546: CURSOR party_id_csr(p_cust_account_id IN NUMBER) IS
547: SELECT party_id
548: FROM hz_cust_accounts
549: WHERE cust_account_id = p_cust_account_id;
550:
551: CURSOR party_site_id_csr(p_account_site_id number) is
552: SELECT party_site_id

Line 3849: FROM hz_cust_accounts hca

3845: -- bug # 7375849 fixed by ateotia (+)
3846: --, substr(hp.party_name, 1,30)
3847: , hp.party_name
3848: -- bug # 7375849 fixed by ateotia (-)
3849: FROM hz_cust_accounts hca
3850: , hz_parties hp
3851: WHERE hca.cust_account_id = p_id
3852: AND hca.party_id = hp.party_id;
3853: