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 2646: FROM ozf_offer_qualifiers a, ozf_offers b

2642: AND a.qualifier_attribute = b.attribute
2643: AND b.query_for = 'ELIG'
2644: UNION
2645: SELECT a.qualifier_id qnum
2646: FROM ozf_offer_qualifiers a, ozf_offers b
2647: WHERE b.qp_list_header_id = ll_list_header_id
2648: AND a.offer_id = b.offer_id
2649: AND a.active_flag = 'Y'
2650: UNION

Line 2671: FROM ozf_offer_qualifiers a, ozf_offers b

2667: AND a.qualifier_attribute = b.attribute
2668: AND b.query_for = 'ELIG'
2669: UNION
2670: SELECT count(a.qualifier_id)
2671: FROM ozf_offer_qualifiers a, ozf_offers b
2672: WHERE b.qp_list_header_id = ll_list_header_id
2673: AND a.offer_id = b.offer_id
2674: AND a.active_flag = 'Y';
2675: