DBA Data[Home] [Help]

APPS.JG_JOURNAL_ALLOCATIONS_PKG dependencies on JG_ZZ_TA_RULE_LINES

Line 208: FROM jg_zz_ta_rule_lines rl

204: , acr.account_range_id account_range_id
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