APPS.QP_PREQ_PUB dependencies on HZ_CUST_ACCOUNTS

Line 14414: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel1,HZ_CUST_ACCOUNTS_U1,CUST_ACCOUNT_ID,1

14410: IF p_cust_account_id IS NOT NULL THEN
14411:
14412: --obtain_gsa indicator_flag
14413: /*
14414: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel1,HZ_CUST_ACCOUNTS_U1,CUST_ACCOUNT_ID,1
14415: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel1,HZ_PARTIES_U1,PARTY_ID,1
14416: */
14417:
14418:

Line 14445: FROM hz_parties hp, hz_cust_accounts hca

14441: BEGIN
14442:
14443: SELECT NVL(gsa_indicator_flag, 'N')
14444: INTO l_gsa_indicator_flag
14445: FROM hz_parties hp, hz_cust_accounts hca
14446: WHERE hp.party_id = hca.party_id
14447: AND hca.cust_account_id = p_cust_account_id ;
14448:
14449: EXCEPTION

Line 14458: FROM hz_parties hp, hz_cust_accounts hca

14454: END;
14455:
14456: END IF;
14457: /* SELECT nvl(gsa_indicator_flag,'N') into l_gsa_indicator_flag
14458: FROM hz_parties hp, hz_cust_accounts hca
14459: WHERE hp.party_id = hca.party_id and hca.cust_account_id = p_cust_account_id;
14460: ELSE
14461: -- treat it as non-GSA customer if p_cust_account_id is NULL
14462: l_gsa_indicator_flag := 'N';