APPS.MSC_SRP_RELEASE dependencies on HZ_PARTIES

Line 726: from hz_parties --ra_customers

722: and rownum < 2;
723:
724: select party_number
725: into l_customer_NAME
726: from hz_parties --ra_customers
727: where party_id = l_customer_id
728: and rownum < 2;
729: Exception
730: when others then

Line 856: FROM Hz_Parties sub,

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

Line 858: Hz_Parties obj

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