DBA Data[Home] [Help]

APPS.OE_ACCEPTANCE_UTIL dependencies on FUN_RULE_BULK_RESULT_GT

Line 167: FROM fun_rule_bulk_result_gt gt,

163: l_inserted_lines NUMBER;
164:
165: CURSOR default_contingencies IS
166: SELECT id, contingency_id, revrec_event_code, expiration_days
167: FROM fun_rule_bulk_result_gt gt,
168: ar_deferral_reasons dr
169: WHERE gt.result_value = dr.contingency_id
170: AND revrec_event_code in ('INVOICING', 'CUSTOMER_ACCEPTANCE')
171: ORDER BY id, revrec_event_code DESC, expiration_days, creation_date DESC;

Line 334: --join fun_rule_bulk_result_gt with ar_deferral_reasons to get all the AR attributes

330: IF l_debug_level > 0 THEN
331: oe_debug_pub.add('Exiting AR_DEFERRAL_REASONS_GRP.default_reasons ' );
332: END IF;
333:
334: --join fun_rule_bulk_result_gt with ar_deferral_reasons to get all the AR attributes
335: --pick one pre-billing or post-billing contingency
336:
337: --1. Pre-billing deferral reason has precedence over post-billing one
338: --2. If there are two pre-billing deferral reasons(or two post-blling without prebilling), we pick the one that has less number of expiration days.