APPS.MSC_SRP_RELEASE dependencies on HZ_CUST_ACCOUNTS_ALL

Line 718: from hz_cust_accounts_all

714: l_ro_release.src_organization_id);
715:
716: /* select cust_account_id,account_number
717: into l_acct_id,l_acct_number
718: from hz_cust_accounts_all
719: where cust_account_id = l_customer_id -- bug # 8299478
720: and customer_type ='I'
721: and rownum < 2;
722: */

Line 726: from hz_parties hp,hz_cust_accounts_all hca --ra_customers

722: */
723:
724: select hp.party_number, hp.party_id
725: into l_customer_NAME,l_party_id
726: from hz_parties hp,hz_cust_accounts_all hca --ra_customers
727: where hp.party_id = hca.party_id
728: and hca.cust_account_id = l_customer_id -- bug # 8299478
729: and hca.customer_type ='I'
730: and rownum < 2;