DBA Data[Home] [Help]

APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on HZ_CUST_ACCOUNTS

Line 717: select max(cust_account_id) from hz_cust_accounts

713: WHERE uses.site_use_id = p_site_use_id
714: AND sites.cust_acct_site_id = uses.cust_acct_site_id;
715:
716: CURSOR c_get_cust_account_id(p_party_id IN NUMBER) IS
717: select max(cust_account_id) from hz_cust_accounts
718: where party_id = p_party_id
719: and status= 'A';
720:
721: -- rimehrot, bug fix 4030022

Line 1925: select max(cust_account_id) from hz_cust_accounts

1921: WHERE offer_id =p_offer_id;
1922:
1923: /*
1924: CURSOR c_get_cust_account_id(p_party_id IN NUMBER) IS
1925: select max(cust_account_id) from hz_cust_accounts
1926: where party_id = p_party_id
1927: and status= 'A';
1928: */
1929: