APPS.OZF_QUAL_MARKET_OPTION_PVT dependencies on OZF_QUALIFIER_MARKET_OPTION

Line 409: SELECT ozf_qualifier_market_option_s.NEXTVAL

405: l_api_name CONSTANT VARCHAR2(30) := 'Create_qual_market_options';
406: l_qual_market_option_id NUMBER;
407: l_dummy NUMBER;
408: CURSOR c_id IS
409: SELECT ozf_qualifier_market_option_s.NEXTVAL
410: FROM dual;
411: CURSOR c_id_exists (l_id IN NUMBER) IS
412: SELECT 1
413: FROM ozf_qualifier_market_option

Line 413: FROM ozf_qualifier_market_option

409: SELECT ozf_qualifier_market_option_s.NEXTVAL
410: FROM dual;
411: CURSOR c_id_exists (l_id IN NUMBER) IS
412: SELECT 1
413: FROM ozf_qualifier_market_option
414: WHERE qualifier_market_option_id = l_id;
415: l_object_version_number NUMBER;
416: BEGIN
417: --initialize

Line 573: FROM ozf_qualifier_market_option

569: )
570: IS
571: CURSOR c_get_qual_mo(p_qualifier_market_option_id NUMBER, p_object_version_number NUMBER) IS
572: SELECT *
573: FROM ozf_qualifier_market_option
574: WHERE qualifier_market_option_id = p_qualifier_market_option_id
575: AND object_version_number = p_object_version_number;
576: -- Hint: Developer need to provide Where clause
577: