APPS.JA_CN_GL_BANK_EXP_PKG dependencies on GL_JE_HEADERS

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

Line 1251: from gl_je_headers gjh

1247: (select name
1248: from gl_je_batches gjb
1249: where gjb.je_batch_id =
1250: (select gjh.je_batch_id
1251: from gl_je_headers gjh
1252: where gjh.je_header_id = p_je_header)));
1253:
1254: EXCEPTION
1255: WHEN NO_DATA_FOUND THEN

Line 1257: FROM GL_JE_HEADERS GJH, FND_USER FU2

1253:
1254: EXCEPTION
1255: WHEN NO_DATA_FOUND THEN
1256: SELECT FU2.USER_NAME into l_approver
1257: FROM GL_JE_HEADERS GJH, FND_USER FU2
1258: WHERE GJH.JE_HEADER_ID =p_je_header
1259: AND gjh.status = 'P'
1260: AND FU2.USER_ID = GJH.LAST_UPDATED_BY;
1261: END;