APPS.JA_CN_GL_BANK_EXP_PKG dependencies on GL_LEDGERS

Line 161: FROM gl_ledgers gls

157: AND FSAV.APPLICATION_COLUMN_NAME = fifsv.APPLICATION_COLUMN_NAME
158: AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'
159: AND fifsv.ID_FLEX_NUM in
160: (SELECT chart_of_accounts_id
161: FROM gl_ledgers gls
162: where gls.ledger_id = pn_ledger_id);
163:
164: --get bsv summary
165: SELECT SUMMARY_FLAG

Line 542: FROM GL_BALANCES GBS, GL_LEDGERS GLS

538: GBS.PERIOD_NET_CR_BEQ,
539: GBS.PERIOD_NET_CR))) YTD,
540: SUM((GBS.BEGIN_BALANCE_DR_BEQ - GBS.BEGIN_BALANCE_CR_BEQ +
541: GBS.PERIOD_NET_DR_BEQ - GBS.PERIOD_NET_CR_BEQ)) YTD_BEQ
542: FROM GL_BALANCES GBS, GL_LEDGERS GLS
543: WHERE GBS.LEDGER_ID = GLS.LEDGER_ID
544: AND GBS.LEDGER_ID =pn_ledger_id
545: AND Ja_Cn_Utility.get_balancing_segment(GBS.CODE_COMBINATION_ID)=pv_bsv
546: AND PERIOD_NAME in