DBA Data[Home] [Help]

APPS.JG_ALLOCATE_JOURNALS_PKG dependencies on JG_ZZ_TA_ACCOUNT_RANGES

Line 275: FROM jg_zz_ta_account_ranges acr,

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

Line 646: 'FROM jg_zz_ta_account_ranges acr '||

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