APPS.CN_RAM_ADJUSTMENTS_PKG dependencies on AR_REVENUE_ADJUSTMENTS

Line 13: -- Join cn_not_trx and ar_revenue_adjustments to get the customer_trx_id

9: debug_level NUMBER DEFAULT NULL,
10: x_org_id NUMBER ) IS
11:
12:
13: -- Join cn_not_trx and ar_revenue_adjustments to get the customer_trx_id
14: -- of the transactions (header level) which have been RAM-adjusted after
15: -- last collection run within the interested period.
16:
17: -- Note : the application_date and last_collected_date used in the where

Line 33: from cn_not_trx cnt, ar_revenue_adjustments ara

29: ara.from_cust_trx_line_id,
30: ara.from_inventory_item_id,
31: ara.from_category_id,
32: ara.line_selection_mode
33: from cn_not_trx cnt, ar_revenue_adjustments ara
34: where
35: nvl(cnt.last_collected_date, cnt.notified_date) <= ara.application_date and
36: cnt.collected_flag = 'Y' and -- has been collected before
37: cnt.source_doc_type = 'AR' and -- AR collection

Line 83: -- Category_id, and mode), which has been identified in ar_revenue_adjustments

79: CLOSE batch_size;
80:
81:
82: -- For each adjustments (distinct on Not_trx_id, Header_id, Line_id, Item_id,
83: -- Category_id, and mode), which has been identified in ar_revenue_adjustments
84: -- table, figure out the trx_line_id of the corresponding transaction lines
85: -- that got adjusted and set the flags.
86:
87: FOR adj IN adj_cursor(x_start_date, x_end_date) LOOP