DBA Data[Home] [Help]

APPS.QP_SOURCING_API_PUB dependencies on HZ_PARTIES

Line 90: from hz_parties hp,hz_cust_accounts hca

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

Line 1685: from hz_parties hp,hz_cust_accounts hca

1681: BEGIN
1682:
1683: SELECT NVL(gsa_indicator_flag,'N')
1684: into G_Customer_Info.gsa_indicator
1685: from hz_parties hp,hz_cust_accounts hca
1686: where hp.party_id = hca.party_id
1687: and hca.cust_account_id = p_cust_id ;
1688:
1689: EXCEPTION