APPS.JA_CN_SI_BANK_DET_PKG dependencies on GL_PERIODS

Line 619: FROM gl_periods

615: AND gjh.je_header_id = gjl.je_header_id
616: AND gjh.ledger_id = pn_ledger_id
617: AND gjh.period_name IN
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

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;