DBA Data[Home] [Help]

APPS.OZF_SUPP_TRADE_PROFILE_PUB dependencies on OZF_CLAIM_STTLMNT_METHODS_ALL

Line 277: FROM ozf_claim_sttlmnt_methods_all cs,

273: IF ( p_supp_trade_profile_rec.settlement_method_supplier_inc <>FND_API.g_miss_char
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'

Line 305: FROM ozf_claim_sttlmnt_methods_all cs,

301: IF ( p_supp_trade_profile_rec.settlement_method_supplier_dec <>FND_API.g_miss_char
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'

Line 332: FROM ozf_claim_sttlmnt_methods_all cs,

328: IF ( p_supp_trade_profile_rec.settlement_method_customer <>FND_API.g_miss_char
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'