DBA Data[Home] [Help]

APPS.JG_ALLOCATE_JOURNALS_PKG dependencies on JG_ZZ_TA_CC_RANGES

Line 276: jg_zz_ta_cc_ranges ccr

272: acr.offset_account,
273: ccr.cc_range_low,
274: ccr.cc_range_high
275: FROM jg_zz_ta_account_ranges acr,
276: jg_zz_ta_cc_ranges ccr
277: WHERE NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cost_center, ccr.cc_range_low)
278: BETWEEN ccr.cc_range_low AND ccr.cc_range_high
279: AND ccr.rule_set_id = JG_JOURNAL_ALLOCATIONS_PKG.G_rule_set_id
280: AND ccr.cc_range_id = acr.cc_range_id (+)

Line 647: ', jg_zz_ta_cc_ranges ccr '||

643: ', acr.account_range_low '||
644: ', acr.account_range_high '||
645: ', acr.offset_account '||
646: 'FROM jg_zz_ta_account_ranges acr '||
647: ', jg_zz_ta_cc_ranges ccr '||
648: 'WHERE ccr.cc_range_id = acr.cc_range_id '||
649: 'AND ccr.rule_set_id = '||TO_CHAR(JG_JOURNAL_ALLOCATIONS_PKG.G_rule_set_id)||') ranges, ';
650:
651: l_non_view_columns := ', ranges.cc_range_id '||