APPS.JG_JOURNAL_ALLOCATIONS_PKG dependencies on JG_ZZ_TA_ACCOUNT_RANGES

Line 209: , jg_zz_ta_account_ranges acr

205: , SUM(rl.allocation_percent) total_percent
206: , COUNT(*) total_num_of_lines
207: , SUM(DECODE(rl.offset_account, NULL, 0, 1)) total_num_of_offsets
208: FROM jg_zz_ta_rule_lines rl
209: , jg_zz_ta_account_ranges acr
210: , jg_zz_ta_cc_ranges ccr
211: , jg_zz_ta_rule_sets rs
212: WHERE rs.rule_set_id = ccr.rule_set_id
213: AND ccr.cc_range_id = acr.cc_range_id

Line 225: ,account_range_low jg_zz_ta_account_ranges.account_range_low%TYPE

221: , acr.offset_account
222: , acr.account_range_id;
223: TYPE ACCOUNT_RANGE_LINE IS RECORD(cc_range_low jg_zz_ta_cc_ranges.cc_range_low%TYPE
224: ,cc_range_high jg_zz_ta_cc_ranges.cc_range_high%TYPE
225: ,account_range_low jg_zz_ta_account_ranges.account_range_low%TYPE
226: ,account_range_high jg_zz_ta_account_ranges.account_range_high%TYPE);
227: TYPE ACCOUNT_RANGE_TABLE IS TABLE OF ACCOUNT_RANGE_LINE INDEX BY BINARY_INTEGER;
228: l_acct_range_arr ACCOUNT_RANGE_TABLE;
229: arr_count BINARY_INTEGER; --:= 0; Default values not allowed in Init. -- running count of number of account ranges

Line 226: ,account_range_high jg_zz_ta_account_ranges.account_range_high%TYPE);

222: , acr.account_range_id;
223: TYPE ACCOUNT_RANGE_LINE IS RECORD(cc_range_low jg_zz_ta_cc_ranges.cc_range_low%TYPE
224: ,cc_range_high jg_zz_ta_cc_ranges.cc_range_high%TYPE
225: ,account_range_low jg_zz_ta_account_ranges.account_range_low%TYPE
226: ,account_range_high jg_zz_ta_account_ranges.account_range_high%TYPE);
227: TYPE ACCOUNT_RANGE_TABLE IS TABLE OF ACCOUNT_RANGE_LINE INDEX BY BINARY_INTEGER;
228: l_acct_range_arr ACCOUNT_RANGE_TABLE;
229: arr_count BINARY_INTEGER; --:= 0; Default values not allowed in Init. -- running count of number of account ranges
230: BEGIN