APPS.OZF_COPY_OFFER_PVT dependencies on OZF_OFFER_QUALIFIERS

Line 1451: SELECT ozf_offer_qualifiers_s.NEXTVAL

1447: PROCEDURE copy_na_market_elig(p_source_object_id IN NUMBER
1448: ,p_new_offer_id IN NUMBER)
1449: IS
1450: CURSOR c_new_qual_id IS
1451: SELECT ozf_offer_qualifiers_s.NEXTVAL
1452: FROM DUAL;
1453:
1454: CURSOR c_qual_id_exists(l_id NUMBER) IS
1455: SELECT 1

Line 1458: FROM ozf_offer_qualifiers

1454: CURSOR c_qual_id_exists(l_id NUMBER) IS
1455: SELECT 1
1456: FROM DUAL
1457: WHERE EXISTS (SELECT 1
1458: FROM ozf_offer_qualifiers
1459: WHERE qualifier_id = l_id);
1460:
1461: CURSOR c_market_elig IS
1462: SELECT *

Line 1463: FROM ozf_offer_qualifiers

1459: WHERE qualifier_id = l_id);
1460:
1461: CURSOR c_market_elig IS
1462: SELECT *
1463: FROM ozf_offer_qualifiers
1464: WHERE offer_id = (SELECT offer_id
1465: FROM ozf_offers
1466: WHERE qp_list_header_id = p_source_object_id);
1467:

Line 1486: INSERT INTO ozf_offer_qualifiers(qualifier_id

1482: EXIT WHEN l_count IS NULL;
1483: END LOOP;
1484:
1485: FOR l_market_elig IN c_market_elig LOOP
1486: INSERT INTO ozf_offer_qualifiers(qualifier_id
1487: ,creation_date
1488: ,created_by
1489: ,last_update_date
1490: ,last_updated_by