APPS.OZF_SUPP_TRADE_PROFILE_PUB dependencies on OZF_LOOKUPS

Line 172: FROM ozf_lookups

168: IF (p_supp_trade_profile_rec.approval_communication <>FND_API.g_miss_char AND
169: p_supp_trade_profile_rec.approval_communication IS NOT NULL ) THEN
170:
171: SELECT COUNT(*) INTO l_comn_chan_count
172: FROM ozf_lookups
173: WHERE lookup_type='OZF_CLAIM_COMMUNICATION'
174: AND lookup_code = p_supp_trade_profile_rec.approval_communication ;
175:
176: IF l_comn_chan_count=0 THEN

Line 213: FROM ozf_lookups

209: IF (p_supp_trade_profile_rec.request_communication <>FND_API.g_miss_char
210: AND p_supp_trade_profile_rec.request_communication IS NOT NULL ) THEN
211:
212: SELECT COUNT(*) INTO l_comn_chan_count
213: FROM ozf_lookups
214: WHERE lookup_type='OZF_REQ_COMMUNICATION'
215: AND lookup_code = p_supp_trade_profile_rec.request_communication ;
216:
217: IF l_comn_chan_count=0 THEN

Line 237: FROM ozf_lookups

233: IF (p_supp_trade_profile_rec.claim_communication <>FND_API.g_miss_char
234: AND p_supp_trade_profile_rec.claim_communication IS NOT NULL) THEN
235:
236: SELECT COUNT(*) INTO l_comn_chan_count
237: FROM ozf_lookups
238: WHERE lookup_type='OZF_CLAIM_COMMUNICATION'
239: AND lookup_code = p_supp_trade_profile_rec.claim_communication ;
240:
241: IF l_comn_chan_count=0 THEN

Line 278: ozf_lookups ol

274: AND p_supp_trade_profile_rec.settlement_method_supplier_inc IS NOT NULL ) THEN
275:
276: SELECT COUNT(*) INTO l_sett_inc_count
277: FROM ozf_claim_sttlmnt_methods_all cs,
278: ozf_lookups ol
279: WHERE cs.settlement_method = ol.lookup_code
280: AND ol.lookup_type = 'OZF_PAYMENT_METHOD'
281: AND cs.source_object_class='PPINCVENDOR'
282: AND cs.org_id = p_supp_trade_profile_rec.org_id

Line 306: ozf_lookups ol

302: AND p_supp_trade_profile_rec.settlement_method_supplier_dec IS NOT NULL ) THEN
303:
304: SELECT COUNT(*) INTO l_sett_dec_count
305: FROM ozf_claim_sttlmnt_methods_all cs,
306: ozf_lookups ol
307: WHERE cs.settlement_method = ol.lookup_code
308: AND ol.lookup_type = 'OZF_PAYMENT_METHOD'
309: AND cs.source_object_class='PPVENDOR'
310: AND cs.org_id = p_supp_trade_profile_rec.org_id

Line 333: ozf_lookups ol

329: AND p_supp_trade_profile_rec.settlement_method_customer IS NOT NULL ) THEN
330:
331: SELECT COUNT(*) INTO l_cust_sett_count
332: FROM ozf_claim_sttlmnt_methods_all cs,
333: ozf_lookups ol
334: WHERE cs.settlement_method = ol.lookup_code
335: AND ol.lookup_type = 'OZF_PAYMENT_METHOD'
336: AND cs.source_object_class='PPCUSTOMER'
337: AND cs.org_id = p_supp_trade_profile_rec.org_id

Line 479: FROM ozf_lookups

475: RAISE FND_API.G_EXC_ERROR ;
476: END IF ;
477:
478: SELECT COUNT(*) INTO l_freq_unit_count
479: FROM ozf_lookups
480: WHERE lookup_type='OZF_AUTOPAY_PERIOD_TYPE'
481: AND lookup_code = p_supp_trade_profile_rec.claim_frequency_unit ;
482:
483: IF ( l_freq_unit_count=0 ) THEN