APPS.OE_PARTY_TOTALS dependencies on HZ_CUST_ACCOUNTS

Line 40: FROM hz_cust_accounts b,

36: CURSOR C_PARTIES IS
37: SELECT DISTINCT a.party_id,
38: a.party_type,
39: a.last_update_date
40: FROM hz_cust_accounts b,
41: hz_parties a
42: WHERE b.party_id = a.party_id;
43:
44: CURSOR C_ORDER_HEADER(p_party_id NUMBER) IS

Line 55: FROM hz_cust_accounts b,

51: a.sold_to_org_id,
52: a.CONVERSION_RATE_DATE,
53: a.ORDERED_DATE,
54: a.ORDER_CATEGORY_CODE
55: FROM hz_cust_accounts b,
56: oe_order_headers_all a
57: WHERE b.party_id = p_party_id
58: AND b.cust_account_id = a.sold_to_org_id
59: AND a.booked_flag = 'Y'