APPS.QP_UTIL_PUB dependencies on HZ_CUST_ACCOUNTS

Line 1535: hz_parties p, hz_cust_accounts c, ra_terms_tl t,

1531: SELECT SUBSTRB(a.agreement_name,1,300) agreement_name, a.agreement_id agreement_id,
1532: a.agreement_type, q.name price_list_name, p.party_name customer_name,
1533: t.name payment_term_name, a.start_date_active, a.end_date_active
1534: FROM oe_agreements_lov_v a, qp_list_headers_vl q,
1535: hz_parties p, hz_cust_accounts c, ra_terms_tl t,
1536: -- qp_list_headers_b l,
1537: oe_transaction_types_all ot
1538: WHERE a.sold_to_org_id IN (
1539: SELECT TO_NUMBER(p_sold_to_org_id) FROM dual

Line 1596: hz_parties p, hz_cust_accounts c --, qp_list_headers_b l

1592: select substr(a.agreement_name,1,300) agreement_name, a.agreement_id agreement_id,
1593: a.agreement_type, q.name price_list_name, p.party_name customer_name,
1594: null payment_term_name, a.start_date_active, a.end_date_active
1595: from oe_agreements_lov_v a, qp_list_headers_vl q,
1596: hz_parties p, hz_cust_accounts c --, qp_list_headers_b l
1597: where a.sold_to_org_id in (
1598: select to_number(p_sold_to_org_id) from dual
1599: union
1600: select -1 from dual