APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_OFFR_MARKET_OPTIONS

Line 1147: FROM ozf_offr_market_options opt

1143: AND qp_list_header_id = p_list_header_id;
1144:
1145: CURSOR c_market_option(p_list_header_id IN NUMBER, p_group_id IN NUMBER) IS
1146: SELECT opt.retroactive_flag
1147: FROM ozf_offr_market_options opt
1148: WHERE opt.GROUP_NUMBER= p_group_id
1149: AND opt.qp_list_header_id = p_list_header_id;
1150:
1151: CURSOR c_current_discount(p_volume IN NUMBER, p_parent_discount_id IN NUMBER) IS

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

1201: ORDER BY volume_from DESC;
1202:
1203: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
1204: SELECT a.discount
1205: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
1206: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
1207: AND b.pbh_offer_discount_id = p_pbh_line_id
1208: AND b.offer_market_option_id = c.offer_market_option_id
1209: AND c.qp_list_header_id = p_qp_list_header_id

Line 4165: FROM ozf_offr_market_options opt

4161: AND qp_list_header_id = p_list_header_id;
4162:
4163: CURSOR c_market_option(p_list_header_id IN NUMBER, p_group_id IN NUMBER) IS
4164: SELECT opt.retroactive_flag
4165: FROM ozf_offr_market_options opt
4166: WHERE opt.group_number = p_group_id
4167: AND opt.qp_list_header_id = p_list_header_id;
4168:
4169: CURSOR c_discount_header(p_discount_line_id IN NUMBER) IS

Line 7868: FROM ozf_offr_market_options opt

7864: AND qp_list_header_id = p_list_header_id;
7865:
7866: CURSOR c_market_option(p_list_header_id IN NUMBER, p_group_id IN NUMBER) IS
7867: SELECT opt.retroactive_flag
7868: FROM ozf_offr_market_options opt
7869: WHERE opt.GROUP_NUMBER= p_group_id
7870: AND opt.qp_list_header_id = p_list_header_id;
7871:
7872: --fix for bug 5975203

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

7887: AND det.source_code = p_source_code;
7888: */
7889: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
7890: SELECT a.discount
7891: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
7892: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
7893: AND b.pbh_offer_discount_id = p_pbh_line_id
7894: AND b.offer_market_option_id = c.offer_market_option_id
7895: AND c.qp_list_header_id = p_qp_list_header_id

Line 8934: FROM ozf_offr_market_options opt

8930: AND qp_list_header_id = p_list_header_id;
8931:
8932: CURSOR c_market_option(p_list_header_id IN NUMBER, p_group_id IN NUMBER) IS
8933: SELECT opt.retroactive_flag
8934: FROM ozf_offr_market_options opt
8935: WHERE opt.GROUP_NUMBER= p_group_id
8936: AND opt.qp_list_header_id = p_list_header_id;
8937:
8938: CURSOR c_current_discount(p_volume IN NUMBER, p_parent_discount_id IN NUMBER) IS

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

9032: ORDER BY volume_from DESC;
9033:
9034: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
9035: SELECT a.discount
9036: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
9037: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
9038: AND b.pbh_offer_discount_id = p_pbh_line_id
9039: AND b.offer_market_option_id = c.offer_market_option_id
9040: AND c.qp_list_header_id = p_qp_list_header_id