APPS.QP_PREQ_PUB dependencies on HZ_CUST_ACCOUNTS

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

14598: IF p_cust_account_id IS NOT NULL THEN
14599:
14600: --obtain_gsa indicator_flag
14601: /*
14602: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel1,HZ_CUST_ACCOUNTS_U1,CUST_ACCOUNT_ID,1
14603: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel1,HZ_PARTIES_U1,PARTY_ID,1
14604: */
14605:
14606:

Line 14633: FROM hz_parties hp, hz_cust_accounts hca

14629: BEGIN
14630:
14631: SELECT NVL(gsa_indicator_flag, 'N')
14632: INTO l_gsa_indicator_flag
14633: FROM hz_parties hp, hz_cust_accounts hca
14634: WHERE hp.party_id = hca.party_id
14635: AND hca.cust_account_id = p_cust_account_id ;
14636:
14637: EXCEPTION

Line 14646: FROM hz_parties hp, hz_cust_accounts hca

14642: END;
14643:
14644: END IF;
14645: /* SELECT nvl(gsa_indicator_flag,'N') into l_gsa_indicator_flag
14646: FROM hz_parties hp, hz_cust_accounts hca
14647: WHERE hp.party_id = hca.party_id and hca.cust_account_id = p_cust_account_id;
14648: ELSE
14649: -- treat it as non-GSA customer if p_cust_account_id is NULL
14650: l_gsa_indicator_flag := 'N';