APPS.OZF_OFFER_ADJ_PVT dependencies on OZF_OFFERS

Line 45: FROM ozf_offers a, ozf_offer_adjustments_b b, ozf_offer_adj_new_lines c

41: RETURN VARCHAR2
42: IS
43: CURSOR c_offerType(cp_offerAdjNewLineId NUMBER) IS
44: SELECT offer_type
45: FROM ozf_offers a, ozf_offer_adjustments_b b, ozf_offer_adj_new_lines c
46: WHERE
47: a.qp_list_header_id = b.list_header_id
48: AND b.offer_adjustment_id = c.offer_adjustment_id
49: AND c.offer_adj_new_line_id = cp_offerAdjNewLineId;

Line 2628: FROM ozf_offers a, ozf_offer_adjustments_b b

2624: IS
2625: CURSOR c_offerType(cp_offerAdjustmentId NUMBER) IS
2626: SELECT
2627: offer_type
2628: FROM ozf_offers a, ozf_offer_adjustments_b b
2629: WHERE a.qp_list_header_id = b.list_header_id
2630: AND b.offer_adjustment_id = cp_offerAdjustmentId;
2631: l_offerType c_offerType%ROWTYPE;
2632: BEGIN

Line 3403: ozf_offer_adj_new_lines a, ozf_offer_adjustments_b b, ozf_offers c

3399: , b.list_header_id
3400: , decode(c.offer_type,'ACCRUAL','Y','N') accrual_flag
3401: , c.modifier_level_code
3402: FROM
3403: ozf_offer_adj_new_lines a, ozf_offer_adjustments_b b, ozf_offers c
3404: WHERE a.offer_adjustment_id = b.offer_adjustment_id
3405: AND b.list_header_id = c.qp_list_header_id
3406: AND a.offer_adj_new_line_id = cp_offerAdjNewLineId;
3407: i NUMBER;

Line 4052: FROM ozf_offers a, ozf_offer_adjustments_b b

4048: IS
4049: CURSOR c_offerType(cp_offerAdjustmentId NUMBER) IS
4050: SELECT
4051: offer_type
4052: FROM ozf_offers a, ozf_offer_adjustments_b b
4053: WHERE a.qp_list_header_id = b.list_header_id
4054: AND b.offer_adjustment_id = cp_offerAdjustmentId;
4055: l_offerType c_offerType%ROWTYPE;
4056: BEGIN

Line 4115: FROM ozf_offer_adjustments_b a, qp_list_headers_b b , ozf_offers c

4111: )
4112: IS
4113: CURSOR c_dates(cp_offerAdjustmentId NUMBER) IS
4114: SELECT a.effective_date , b.start_date_active , a.list_header_id , c.offer_type , c.object_version_number
4115: FROM ozf_offer_adjustments_b a, qp_list_headers_b b , ozf_offers c
4116: WHERE a.list_header_id = b.list_header_id
4117: AND b.list_header_id = c.qp_list_header_id
4118: AND a.offer_adjustment_id = cp_offerAdjustmentId ;
4119: