APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on OZF_OFFER_QUALIFIERS

Line 561: FROM ozf_offer_qualifiers

557: WHERE qp_list_header_id = p_list_header_id;
558:
559: CURSOR c_no_groups(l_offer_id NUMBER) IS
560: SELECT COUNT(*)
561: FROM ozf_offer_qualifiers
562: WHERE offer_id = l_offer_id
563: AND qualifier_id = nvl(p_qnum,qualifier_id)
564: AND active_flag = 'Y';
565:

Line 568: FROM ozf_offer_qualifiers

564: AND active_flag = 'Y';
565:
566: CURSOR c_groups(l_offer_id NUMBER) IS
567: SELECT qualifier_id
568: FROM ozf_offer_qualifiers
569: WHERE offer_id = l_offer_id
570: AND qualifier_id = nvl(p_qnum,qualifier_id)
571: AND active_flag = 'Y';
572:

Line 595: FROM ozf_offer_qualifiers

591: 'SHIP_TO', 'QUALIFIER_ATTRIBUTE11',
592: qualifier_attribute) qualifier_attribute,
593: qualifier_attr_value,
594: '=' comparison_operator_code
595: FROM ozf_offer_qualifiers
596: WHERE qualifier_id = p_qualifier_id;
597:
598: l_api_name CONSTANT VARCHAR2(30) := 'refresh_netaccrual_parties';
599: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 2589: FROM ozf_offer_qualifiers a, ozf_offers b

2585: AND a.qualifier_attribute = b.attribute
2586: AND b.query_for = 'ELIG'
2587: UNION
2588: SELECT a.qualifier_id qnum
2589: FROM ozf_offer_qualifiers a, ozf_offers b
2590: WHERE b.qp_list_header_id = ll_list_header_id
2591: AND a.offer_id = b.offer_id
2592: AND a.active_flag = 'Y'
2593: UNION

Line 2614: FROM ozf_offer_qualifiers a, ozf_offers b

2610: AND a.qualifier_attribute = b.attribute
2611: AND b.query_for = 'ELIG'
2612: UNION
2613: SELECT count(a.qualifier_id)
2614: FROM ozf_offer_qualifiers a, ozf_offers b
2615: WHERE b.qp_list_header_id = ll_list_header_id
2616: AND a.offer_id = b.offer_id
2617: AND a.active_flag = 'Y';
2618: