APPS.QP_SOURCING_API_PUB dependencies on HZ_PARTIES

Line 91: from hz_parties hp,hz_cust_accounts hca

87:
88: IF( G_Customer_Info.gsa_indicator is null) THEN
89: SELECT NVL(gsa_indicator_flag,'N')
90: into G_Customer_Info.gsa_indicator
91: from hz_parties hp,hz_cust_accounts hca
92: where hp.party_id = hca.party_id
93: and hca.cust_account_id = p_cust_id ;
94:
95: G_GSA_INDICATOR_FLAGS(p_cust_id) := G_Customer_Info.gsa_indicator;

Line 1677: from hz_parties hp,hz_cust_accounts hca

1673: BEGIN
1674:
1675: SELECT NVL(gsa_indicator_flag,'N')
1676: into G_Customer_Info.gsa_indicator
1677: from hz_parties hp,hz_cust_accounts hca
1678: where hp.party_id = hca.party_id
1679: and hca.cust_account_id = p_cust_id ;
1680:
1681: EXCEPTION