APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on OZF_OFFER_QUALIFIERS

Line 148: FROM ozf_offer_qualifiers

144: -- Partner Referral Net Accrual Offers
145: -- Will always have Territory as a qualifier
146: CURSOR c_terr_id IS
147: SELECT qualifier_attr_value terr_id
148: FROM ozf_offer_qualifiers
149: WHERE offer_id = p_offer_id;
150:
151: CURSOR c_terr_qual_id(p_terr_id NUMBER) IS
152: SELECT terr_qual_id

Line 237: FROM ozf_offer_qualifiers

233: IS
234:
235: CURSOR c_no_groups IS
236: SELECT COUNT(*)
237: FROM ozf_offer_qualifiers
238: WHERE offer_id = p_offer_id
239: AND active_flag = 'Y';
240:
241: CURSOR c_groups IS

Line 243: FROM ozf_offer_qualifiers

239: AND active_flag = 'Y';
240:
241: CURSOR c_groups IS
242: SELECT qualifier_id
243: FROM ozf_offer_qualifiers
244: WHERE offer_id = p_offer_id
245: AND active_flag = 'Y';
246:
247: CURSOR c_qualifiers(p_qualifier_id NUMBER) IS

Line 268: FROM ozf_offer_qualifiers

264: 'SHIP_TO', 'QUALIFIER_ATTRIBUTE11',
265: qualifier_attribute) qualifier_attribute,
266: qualifier_attr_value,
267: '=' comparison_operator_code
268: FROM ozf_offer_qualifiers
269: WHERE qualifier_id = p_qualifier_id;
270:
271: l_api_name CONSTANT VARCHAR2(30) := 'refresh_parties';
272: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 458: FND_DSQL.add_text(' FROM ozf_offer_qualifiers WHERE offer_id = ');

454: -- FND_DSQL.add_text(' UNION select -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
455: FND_DSQL.add_text(' UNION select -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
456: FND_DSQL.add_text(' to_number(qualifier_attr_value) site_use_id, ');
457: FND_DSQL.add_text(' qualifier_context||'':''||qualifier_attribute site_use_code ');
458: FND_DSQL.add_text(' FROM ozf_offer_qualifiers WHERE offer_id = ');
459: FND_DSQL.add_bind(p_offer_id);
460: FND_DSQL.add_text(' and qualifier_context||'':''||qualifier_attribute not in ');
461: FND_DSQL.add_text(' (''CUSTOMER:PRICING_ATTRIBUTE11'',''CUSTOMER:QUALIFIER_ATTRIBUTE14'')');
462: FND_DSQL.add_text(' and qualifier_context not in (''MODLIST'') ');

Line 2143: FROM ozf_offer_qualifiers offer_qual,

2139: -- Used to Validate country code for PRM Net Accrual Offer
2140:
2141: CURSOR c_terr_countries ( p_offer_id IN NUMBER) IS
2142: SELECT terr_val.low_value_char
2143: FROM ozf_offer_qualifiers offer_qual,
2144: jtf_terr_qual_all terr_qual,
2145: jtf_terr_values_all terr_val
2146: WHERE offer_qual.offer_id = p_offer_id
2147: AND offer_qual.qualifier_attr_value = terr_qual.terr_id