APPS.OZF_OFFER_ADJ_PVT dependencies on OZF_OFFERS

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

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

Line 1132: FROM ozf_offers

1128: WHERE offer_id = p_offer_id;
1129:
1130: CURSOR c_get_offer_hdr (p_list_header_id IN NUMBER) IS
1131: SELECT custom_setup_id
1132: FROM ozf_offers
1133: WHERE qp_list_header_id = p_list_header_id;
1134:
1135: CURSOR c_listLineId IS
1136: SELECT adjl.list_line_id

Line 2912: FROM ozf_offers a, ozf_offer_adjustments_b b

2908: IS
2909: CURSOR c_offerType(cp_offerAdjustmentId NUMBER) IS
2910: SELECT
2911: offer_type
2912: FROM ozf_offers a, ozf_offer_adjustments_b b
2913: WHERE a.qp_list_header_id = b.list_header_id
2914: AND b.offer_adjustment_id = cp_offerAdjustmentId;
2915: l_offerType c_offerType%ROWTYPE;
2916: BEGIN

Line 3617: FROM ozf_offers

3613: FROM dual;
3614:
3615: CURSOR c_get_offer_hdr (p_list_header_id IN NUMBER) IS
3616: SELECT custom_setup_id
3617: FROM ozf_offers
3618: WHERE qp_list_header_id = p_list_header_id;
3619:
3620: CURSOR c_get_category_set_id(p_category_id IN NUMBER)IS
3621: SELECT b.category_set_id

Line 3776: FROM ozf_offers

3772:
3773:
3774: CURSOR c_offer_type (p_list_header_id IN NUMBER) IS
3775: SELECT custom_setup_id
3776: FROM ozf_offers
3777: WHERE qp_list_header_id = p_list_header_id;
3778:
3779: BEGIN
3780: -- initialize

Line 3949: ozf_offer_adj_new_lines a, ozf_offer_adjustments_b b, ozf_offers c

3945: , b.list_header_id
3946: , decode(c.offer_type,'ACCRUAL','Y','N') accrual_flag
3947: , c.modifier_level_code
3948: FROM
3949: ozf_offer_adj_new_lines a, ozf_offer_adjustments_b b, ozf_offers c
3950: WHERE a.offer_adjustment_id = b.offer_adjustment_id
3951: AND b.list_header_id = c.qp_list_header_id
3952: AND a.offer_adj_new_line_id = cp_offerAdjNewLineId;
3953: i NUMBER;

Line 4598: FROM ozf_offers a, ozf_offer_adjustments_b b

4594: IS
4595: CURSOR c_offerType(cp_offerAdjustmentId NUMBER) IS
4596: SELECT
4597: offer_type
4598: FROM ozf_offers a, ozf_offer_adjustments_b b
4599: WHERE a.qp_list_header_id = b.list_header_id
4600: AND b.offer_adjustment_id = cp_offerAdjustmentId;
4601: l_offerType c_offerType%ROWTYPE;
4602: BEGIN

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

4659: CURSOR c_dates(cp_offerAdjustmentId NUMBER) IS
4660: SELECT a.effective_date , b.start_date_active , a.list_header_id
4661: ,c.offer_type , c.object_version_number
4662: ,c.custom_setup_id
4663: FROM ozf_offer_adjustments_b a, qp_list_headers_b b , ozf_offers c
4664: WHERE a.list_header_id = b.list_header_id
4665: AND b.list_header_id = c.qp_list_header_id
4666: AND a.offer_adjustment_id = cp_offerAdjustmentId ;
4667: