DBA Data[Home] [Help]

APPS.OE_ACCEPTANCE_UTIL dependencies on FUN_RULE_BULK_RESULT_GT

Line 177: FROM fun_rule_bulk_result_gt gt,

173: l_inserted_lines NUMBER;
174:
175: CURSOR default_contingencies IS
176: SELECT id, contingency_id, revrec_event_code, expiration_days
177: FROM fun_rule_bulk_result_gt gt,
178: ar_deferral_reasons dr
179: WHERE gt.result_value = dr.contingency_id
180: AND revrec_event_code in ('INVOICING', 'CUSTOMER_ACCEPTANCE')
181: ORDER BY id, revrec_event_code DESC, expiration_days, creation_date DESC;

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

368: IF l_debug_level > 0 THEN
369: oe_debug_pub.add('Exiting AR_DEFERRAL_REASONS_GRP.default_reasons ' );
370: END IF;
371:
372: --join fun_rule_bulk_result_gt with ar_deferral_reasons to get all the AR attributes
373: --pick one pre-billing or post-billing contingency
374:
375: --1. Pre-billing deferral reason has precedence over post-billing one
376: --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.