DBA Data[Home] [Help]

APPS.JG_JOURNAL_ALLOCATIONS_PKG dependencies on JG_ZZ_TA_RULE_SETS

Line 211: , jg_zz_ta_rule_sets rs

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
214: AND acr.account_range_id = rl.account_range_id (+)
215: AND rs.rule_set_id = JG_JOURNAL_ALLOCATIONS_PKG.G_rule_set_id