APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_ACTIVITY_CUSTOMERS

Line 219: FROM ozf_activity_customers

215: WHERE cust_account_id = p_sold_to_org_id;
216:
217: CURSOR c_customer_qualified(p_invoice_to_org_id IN NUMBER, p_ship_to_org_id IN NUMBER, p_party_id NUMBER) IS
218: SELECT 'Y', object_type, qp_qualifier_group
219: FROM ozf_activity_customers
220: WHERE (
221: (site_use_id = p_invoice_to_org_id AND site_use_code = 'BILL_TO') OR
222: (site_use_id = p_ship_to_org_id AND site_use_code = 'SHIP_TO') OR
223: (party_id = p_party_id AND site_use_code IS NULL) OR

Line 232: FROM ozf_activity_customers

228: AND ROWNUM = 1;
229:
230: CURSOR c_cust_acct_qualified(p_sold_to_org_id IN NUMBER, p_party_id NUMBER) IS
231: SELECT 'Y', object_type, qp_qualifier_group
232: FROM ozf_activity_customers
233: WHERE (
234: (cust_account_id = p_sold_to_org_id) OR
235: (party_id = p_party_id AND site_use_code IS NULL) OR
236: (party_id = -1)