APPS.OZF_VOLUME_OFFER_QUAL_PVT dependencies on OZF_QUALIFIER_MARKET_OPTION

Line 398: WHERE offer_market_option_id = (SELECT offer_market_option_id FROM ozf_qualifier_market_option WHERE qp_qualifier_id = p_qp_qualifier_id);

394:
395: CURSOR c_mkt_opt_dtail(p_qp_qualifier_id NUMBER)
396: IS
397: SELECT offer_market_option_id, object_version_number FROM ozf_offr_market_options
398: WHERE offer_market_option_id = (SELECT offer_market_option_id FROM ozf_qualifier_market_option WHERE qp_qualifier_id = p_qp_qualifier_id);
399:
400: l_mkt_opt_dtail c_mkt_opt_dtail%ROWTYPE;
401: l_mkt_option_found VARCHAR2(1) := 'N';
402: l_mo_id NUMBER;

Line 407: SELECT * FROM ozf_qualifier_market_option

403: l_mo_rec OZF_offer_Market_Options_PVT.vo_mo_rec_type;
404: l_qual_mo_rec OZF_QUAL_MARKET_OPTION_PVT.qual_mo_rec_type;
405:
406: CURSOR c_qual_mo(p_qualifier_id NUMBER) IS
407: SELECT * FROM ozf_qualifier_market_option
408: WHERE qp_qualifier_id = p_qualifier_id;
409:
410: l_qual_mo c_qual_mo%ROWTYPE;
411:

Line 696: WHERE offer_market_option_id = (SELECT offer_market_option_id FROM ozf_qualifier_market_option WHERE qp_qualifier_id = p_qp_qualifier_id);

692:
693: CURSOR c_mkt_opt_dtail(p_qp_qualifier_id NUMBER)
694: IS
695: SELECT offer_market_option_id, object_version_number FROM ozf_offr_market_options
696: WHERE offer_market_option_id = (SELECT offer_market_option_id FROM ozf_qualifier_market_option WHERE qp_qualifier_id = p_qp_qualifier_id);
697:
698: l_mkt_opt_dtail c_mkt_opt_dtail%ROWTYPE;
699: l_mkt_option_found VARCHAR2(1);
700:

Line 703: SELECT qualifier_market_option_id, object_version_number FROM ozf_qualifier_market_option

699: l_mkt_option_found VARCHAR2(1);
700:
701: CURSOR c_qual_mo(p_qualifier_id NUMBER)
702: IS
703: SELECT qualifier_market_option_id, object_version_number FROM ozf_qualifier_market_option
704: WHERE qp_qualifier_id = p_qualifier_id;
705: l_qual_mo c_qual_mo%ROWTYPE;
706:
707: CURSOR c_qualifierContext(cp_qualifierId NUMBER) IS