APPS.OZF_COPY_OFFER_PVT dependencies on OZF_OFFER_QUALIFIERS

Line 1424: SELECT ozf_offer_qualifiers_s.NEXTVAL

1420: PROCEDURE copy_na_market_elig(p_source_object_id IN NUMBER
1421: ,p_new_offer_id IN NUMBER)
1422: IS
1423: CURSOR c_new_qual_id IS
1424: SELECT ozf_offer_qualifiers_s.NEXTVAL
1425: FROM DUAL;
1426:
1427: CURSOR c_qual_id_exists(l_id NUMBER) IS
1428: SELECT 1

Line 1431: FROM ozf_offer_qualifiers

1427: CURSOR c_qual_id_exists(l_id NUMBER) IS
1428: SELECT 1
1429: FROM DUAL
1430: WHERE EXISTS (SELECT 1
1431: FROM ozf_offer_qualifiers
1432: WHERE qualifier_id = l_id);
1433:
1434: CURSOR c_market_elig IS
1435: SELECT *

Line 1436: FROM ozf_offer_qualifiers

1432: WHERE qualifier_id = l_id);
1433:
1434: CURSOR c_market_elig IS
1435: SELECT *
1436: FROM ozf_offer_qualifiers
1437: WHERE offer_id = (SELECT offer_id
1438: FROM ozf_offers
1439: WHERE qp_list_header_id = p_source_object_id);
1440:

Line 1459: INSERT INTO ozf_offer_qualifiers(qualifier_id

1455: EXIT WHEN l_count IS NULL;
1456: END LOOP;
1457:
1458: FOR l_market_elig IN c_market_elig LOOP
1459: INSERT INTO ozf_offer_qualifiers(qualifier_id
1460: ,creation_date
1461: ,created_by
1462: ,last_update_date
1463: ,last_updated_by