DBA Data[Home] [Help]

APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on HZ_CUST_ACCOUNTS

Line 848: select max(cust_account_id) from hz_cust_accounts

844: WHERE uses.site_use_id = p_site_use_id
845: AND sites.cust_acct_site_id = uses.cust_acct_site_id;
846:
847: CURSOR c_get_cust_account_id(p_party_id IN NUMBER) IS
848: select max(cust_account_id) from hz_cust_accounts
849: where party_id = p_party_id
850: and status= 'A';
851:
852: -- rimehrot, bug fix 4030022

Line 2447: select max(cust_account_id) from hz_cust_accounts

2443: WHERE offer_id =p_offer_id;
2444:
2445: /*
2446: CURSOR c_get_cust_account_id(p_party_id IN NUMBER) IS
2447: select max(cust_account_id) from hz_cust_accounts
2448: where party_id = p_party_id
2449: and status= 'A';
2450: */
2451: