APPS.JA_CN_SI_BANK_DET_PKG dependencies on GL_LEDGERS

Line 71: gl_ledgers gl,

67: ar.tape_version software_version,
68: fcv.name,
69: jcspa.cnao_stand_ver
70: FROM JA_CN_SYSTEM_BANK_PARAMS_ALL_V jcspa,
71: gl_ledgers gl,
72: ad_releases ar,
73: fnd_currencies_vl fcv
74: WHERE ar.release_id = (SELECT max(release_id) FROM ad_releases)
75: AND fcv.currency_code = gl.currency_code

Line 279: FROM gl_ledgers gls

275: fifsv.APPLICATION_COLUMN_NAME
276: AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'
277: AND fifsv.ID_FLEX_NUM in
278: (SELECT chart_of_accounts_id
279: FROM gl_ledgers gls
280: where gls.ledger_id = pn_ledger_id))
281: AND flex_value = pv_bsv
282: ORDER by flex_value;
283:

Line 346: FROM gl_ledgers gls

342: fifsv.APPLICATION_COLUMN_NAME
343: AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'
344: AND fifsv.ID_FLEX_NUM =
345: (SELECT chart_of_accounts_id
346: FROM gl_ledgers gls
347: where gls.ledger_id = pn_ledger_id))
348: and ffv.FLEX_VALUE = pv_bsv;
349:
350: --Ja_Cn_Utility.Add_Sub_Root_Node('COMMERCIAL_BANK_ORG', Ja_Cn_Utility.GV_TAG_TYPE_START);

Line 435: FROM gl_ledgers gls

431: AND FSAV.APPLICATION_COLUMN_NAME = fifsv.APPLICATION_COLUMN_NAME
432: AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'
433: AND fifsv.ID_FLEX_NUM in
434: (SELECT chart_of_accounts_id
435: FROM gl_ledgers gls
436: where gls.ledger_id = pn_ledger_id);
437:
438: --get bsv summary
439: SELECT SUMMARY_FLAG

Line 622: FROM gl_ledgers

618: (SELECT period_name
619: FROM gl_periods
620: WHERE PERIOD_SET_NAME =
621: (SELECT PERIOD_SET_NAME
622: FROM gl_ledgers
623: WHERE ledger_id = pn_ledger_id
624: AND PERIOD_YEAR = pn_accounting_year)
625:
626: )

Line 699: FROM GL_PERIODS GP, GL_LEDGERS GLD

695: -- to get accounting periods
696: CURSOR accounting_periods_cur(ln_accounting_year NUMBER,
697: ln_ledger_id NUMBER) IS
698: SELECT GP.PERIOD_YEAR, GP.PERIOD_NUM, GP.START_DATE, GP.END_DATE
699: FROM GL_PERIODS GP, GL_LEDGERS GLD
700: WHERE GP.PERIOD_YEAR = ln_accounting_year
701: AND GP.PERIOD_SET_NAME = GLD.PERIOD_SET_NAME
702: AND GP.PERIOD_TYPE= GLD.ACCOUNTED_PERIOD_TYPE
703: AND GLD.LEDGER_ID = ln_ledger_id;

Line 916: FROM gl_ledgers gls

912: AND FSAV.APPLICATION_COLUMN_NAME = fifsv.APPLICATION_COLUMN_NAME
913: AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
914: AND fifsv.ID_FLEX_NUM in
915: (SELECT chart_of_accounts_id
916: FROM gl_ledgers gls
917: where gls.ledger_id = pn_ledger_id);
918:
919: Ja_Cn_Utility.Add_Sub_Root_Node('INTER_SHEET_ACC_FILE',
920: Ja_Cn_Utility.GV_TAG_TYPE_START);

Line 1089: FROM gl_ledgers gls

1085: AND FSAV.APPLICATION_COLUMN_NAME = fifsv.APPLICATION_COLUMN_NAME
1086: AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
1087: AND fifsv.ID_FLEX_NUM in
1088: (SELECT chart_of_accounts_id
1089: FROM gl_ledgers gls
1090: where gls.ledger_id = pn_ledger_id);
1091: Ja_Cn_Utility.Add_Sub_Root_Node('EXTRA_SHEET_ACC_FILE',
1092: Ja_Cn_Utility.GV_TAG_TYPE_START);
1093: