APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on QP_LIST_HEADERS

Line 2332: qp_list_headers l,

2328: o.custom_setup_id,
2329: af.forecast_uom_code,
2330: o.fund_request_curr_code curr_code
2331: FROM ozf_offers o,
2332: qp_list_headers l,
2333: ozf_act_offers ao,
2334: ams_campaigns_vl ct,
2335: ozf_act_forecasts_all af
2336: WHERE o.qp_list_header_id = NVL(p_offer_id,o.qp_list_header_id)

Line 3815: FROM ozf_offers o, qp_list_headers l

3811: /*
3812: DELETE FROM ozf_activity_customers
3813: WHERE object_id IN (
3814: SELECT l.list_header_id
3815: FROM ozf_offers o, qp_list_headers l
3816: WHERE o.status_code IN ('CANCELLED', 'TERMINATED', 'CLOSED')
3817: AND o.qp_list_header_id = l.list_header_id
3818: )
3819: AND object_class = 'OFFR';

Line 3824: FROM ozf_offers o, qp_list_headers l

3820:
3821: DELETE FROM ozf_activity_products
3822: WHERE object_id IN (
3823: SELECT l.list_header_id
3824: FROM ozf_offers o, qp_list_headers l
3825: WHERE o.status_code IN ('CANCELLED', 'TERMINATED', 'CLOSED')
3826: AND o.qp_list_header_id = l.list_header_id
3827: )
3828: AND object_class = 'OFFR';

Line 3834: FROM OZF_OFFERS O, QP_LIST_HEADERS L

3830:
3831: DELETE FROM OZF_ACTIVITY_CUSTOMERS b
3832: WHERE
3833: exists ( SELECT L.LIST_HEADER_ID
3834: FROM OZF_OFFERS O, QP_LIST_HEADERS L
3835: WHERE O.STATUS_CODE IN ('CANCELLED', 'TERMINATED', 'CLOSED') AND
3836: O.QP_LIST_HEADER_ID = L.LIST_HEADER_ID and
3837: b.object_id = l.list_header_id ) AND OBJECT_CLASS = 'OFFR';
3838:

Line 3842: FROM OZF_OFFERS O, QP_LIST_HEADERS L

3838:
3839: DELETE FROM OZF_ACTIVITY_PRODUCTS b
3840: WHERE
3841: exists ( SELECT L.LIST_HEADER_ID
3842: FROM OZF_OFFERS O, QP_LIST_HEADERS L
3843: WHERE O.STATUS_CODE IN ('CANCELLED', 'TERMINATED', 'CLOSED') AND
3844: O.QP_LIST_HEADER_ID = L.LIST_HEADER_ID and
3845: b.object_id = l.list_header_id ) AND OBJECT_CLASS = 'OFFR';
3846: