DBA Data[Home] [Help]

APPS.JA_CN_GL_BANK_EXP_PKG dependencies on GL_JE_LINES

Line 780: FROM GL_JE_HEADERS GJH, GL_JE_LINES GJL

776: SUM(GJL.ENTERED_DR) ENTERED_DR,
777: SUM(GJL.ACCOUNTED_DR) ACCOUNTED_DR ,
778: SUM(GJL.ENTERED_CR) ENTERED_CR,
779: SUM(GJL.ACCOUNTED_CR) ACCOUNTED_CR
780: FROM GL_JE_HEADERS GJH, GL_JE_LINES GJL
781: WHERE GJH.JE_HEADER_ID = GJL.JE_HEADER_ID
782: AND gjh.status = 'P'
783: AND JA_CN_UTILITY.get_balancing_segment(GJL.CODE_COMBINATION_ID) = pv_bsv
784: AND GJH.LEDGER_ID = pn_ledger_id

Line 1013: FROM GL_JE_HEADERS GJH, GL_JE_LINES GJL, FND_USER FU, FND_USER FU2

1009: TO_CHAR(GJH.DEFAULT_EFFECTIVE_DATE, 'YYYY') PERIOD_YEAR,
1010: GJH.JE_HEADER_ID,
1011: GJH.PERIOD_NAME,
1012: GJH.JE_BATCH_ID
1013: FROM GL_JE_HEADERS GJH, GL_JE_LINES GJL, FND_USER FU, FND_USER FU2
1014: WHERE GJH.JE_HEADER_ID = GJL.JE_HEADER_ID
1015: AND gjh.status = 'P'
1016: AND FU.USER_ID = GJL.CREATED_BY
1017: AND FU2.USER_ID = GJL.LAST_UPDATED_BY