APPS.QP_PRC_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 298: FROM HZ_CUST_ACCOUNTS

294: -- Query Customer Class Code.
295:
296: SELECT CUSTOMER_CLASS_CODE
297: INTO l_class_code
298: FROM HZ_CUST_ACCOUNTS
299: WHERE CUST_ACCOUNT_ID = p_sold_to_org_id;
300:
301: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_CUST_CLASS', 1);
302:

Line 1259: FROM HZ_CUST_ACCOUNTS cust_acct,HZ_PARTIES party

1255: IF l_GSA IS NULL THEN
1256: IF p_sold_to_org_id IS NOT NULL THEN
1257: SELECT NVL( DECODE(party.PARTY_TYPE,'ORGANIZATION',party.GSA_INDICATOR_FLAG, 'N'),'N' )
1258: INTO l_gsa
1259: FROM HZ_CUST_ACCOUNTS cust_acct,HZ_PARTIES party
1260: WHERE cust_acct.PARTY_ID = party.PARTY_ID and
1261: cust_acct.CUST_ACCOUNT_ID = p_sold_to_org_id;
1262: END IF;
1263: