APPS.MSC_SRP_RELEASE dependencies on HZ_PARTIES

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;

Line 858: FROM Hz_Parties sub,

854: /* For Getting a contact point for this customer */
855: BEGIN
856: SELECT r.party_id
857: INTO l_customer_contact_id
858: FROM Hz_Parties sub,
859: Hz_Relationships r,
860: Hz_Parties obj
861: WHERE r.object_id = l_party_id
862: --AND r.party_id = p_customer_contact_id

Line 860: Hz_Parties obj

856: SELECT r.party_id
857: INTO l_customer_contact_id
858: FROM Hz_Parties sub,
859: Hz_Relationships r,
860: Hz_Parties obj
861: WHERE r.object_id = l_party_id
862: --AND r.party_id = p_customer_contact_id
863: AND sub.status = 'A'
864: AND r.status = 'A'