APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_OFFR_MARKET_OPTIONS

Line 987: FROM ozf_offr_market_options opt

983: AND qp_list_header_id = p_list_header_id;
984:
985: CURSOR c_market_option(p_list_header_id IN NUMBER, p_group_id IN NUMBER) IS
986: SELECT opt.retroactive_flag
987: FROM ozf_offr_market_options opt
988: WHERE opt.GROUP_NUMBER= p_group_id
989: AND opt.qp_list_header_id = p_list_header_id;
990:
991: CURSOR c_current_discount(p_volume IN NUMBER, p_parent_discount_id IN NUMBER) IS

Line 1044: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c

1040: ORDER BY volume_from DESC;
1041:
1042: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
1043: SELECT a.discount
1044: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
1045: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
1046: AND b.pbh_offer_discount_id = p_pbh_line_id
1047: AND b.offer_market_option_id = c.offer_market_option_id
1048: AND c.qp_list_header_id = p_qp_list_header_id

Line 3812: FROM ozf_offr_market_options opt

3808: AND qp_list_header_id = p_list_header_id;
3809:
3810: CURSOR c_market_option(p_list_header_id IN NUMBER, p_group_id IN NUMBER) IS
3811: SELECT opt.retroactive_flag
3812: FROM ozf_offr_market_options opt
3813: WHERE opt.GROUP_NUMBER= p_group_id
3814: AND opt.qp_list_header_id = p_list_header_id;
3815:
3816: --fix for bug 5975203

Line 3835: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c

3831: AND det.source_code = p_source_code;
3832: */
3833: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
3834: SELECT a.discount
3835: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
3836: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
3837: AND b.pbh_offer_discount_id = p_pbh_line_id
3838: AND b.offer_market_option_id = c.offer_market_option_id
3839: AND c.qp_list_header_id = p_qp_list_header_id

Line 4644: FROM ozf_offr_market_options opt

4640: AND qp_list_header_id = p_list_header_id;
4641:
4642: CURSOR c_market_option(p_list_header_id IN NUMBER, p_group_id IN NUMBER) IS
4643: SELECT opt.retroactive_flag
4644: FROM ozf_offr_market_options opt
4645: WHERE opt.GROUP_NUMBER= p_group_id
4646: AND opt.qp_list_header_id = p_list_header_id;
4647:
4648: CURSOR c_current_discount(p_volume IN NUMBER, p_parent_discount_id IN NUMBER) IS

Line 4746: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c

4742: ORDER BY volume_from DESC;
4743:
4744: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
4745: SELECT a.discount
4746: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
4747: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
4748: AND b.pbh_offer_discount_id = p_pbh_line_id
4749: AND b.offer_market_option_id = c.offer_market_option_id
4750: AND c.qp_list_header_id = p_qp_list_header_id