APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on QP_LIST_HEADERS

Line 2389: qp_list_headers l,

2385: o.custom_setup_id,
2386: af.forecast_uom_code,
2387: o.fund_request_curr_code curr_code
2388: FROM ozf_offers o,
2389: qp_list_headers l,
2390: ozf_act_offers ao,
2391: ams_campaigns_vl ct,
2392: ozf_act_forecasts_all af
2393: WHERE o.qp_list_header_id = NVL(p_offer_id,o.qp_list_header_id)

Line 3875: FROM ozf_offers o, qp_list_headers l

3871: /*
3872: DELETE FROM ozf_activity_customers
3873: WHERE object_id IN (
3874: SELECT l.list_header_id
3875: FROM ozf_offers o, qp_list_headers l
3876: WHERE o.status_code IN ('CANCELLED', 'TERMINATED', 'CLOSED')
3877: AND o.qp_list_header_id = l.list_header_id
3878: )
3879: AND object_class = 'OFFR';

Line 3884: FROM ozf_offers o, qp_list_headers l

3880:
3881: DELETE FROM ozf_activity_products
3882: WHERE object_id IN (
3883: SELECT l.list_header_id
3884: FROM ozf_offers o, qp_list_headers l
3885: WHERE o.status_code IN ('CANCELLED', 'TERMINATED', 'CLOSED')
3886: AND o.qp_list_header_id = l.list_header_id
3887: )
3888: AND object_class = 'OFFR';

Line 3894: FROM OZF_OFFERS O, QP_LIST_HEADERS L

3890:
3891: DELETE FROM OZF_ACTIVITY_CUSTOMERS b
3892: WHERE
3893: exists ( SELECT L.LIST_HEADER_ID
3894: FROM OZF_OFFERS O, QP_LIST_HEADERS L
3895: WHERE O.STATUS_CODE IN ('CANCELLED', 'TERMINATED', 'CLOSED') AND
3896: O.QP_LIST_HEADER_ID = L.LIST_HEADER_ID and
3897: b.object_id = l.list_header_id ) AND OBJECT_CLASS = 'OFFR';
3898:

Line 3902: FROM OZF_OFFERS O, QP_LIST_HEADERS L

3898:
3899: DELETE FROM OZF_ACTIVITY_PRODUCTS b
3900: WHERE
3901: exists ( SELECT L.LIST_HEADER_ID
3902: FROM OZF_OFFERS O, QP_LIST_HEADERS L
3903: WHERE O.STATUS_CODE IN ('CANCELLED', 'TERMINATED', 'CLOSED') AND
3904: O.QP_LIST_HEADER_ID = L.LIST_HEADER_ID and
3905: b.object_id = l.list_header_id ) AND OBJECT_CLASS = 'OFFR';
3906: