DBA Data[Home] [Help]

APPS.JAI_CMN_RPT_BBR_PKG dependencies on GL_JE_LINES

Line 76: gl_je_lines gll,

72: --SRW.message(3, to_char(NVL(amt, 0)));
73:
74: SELECT SUM(accounted_dr) INTO amt1
75: FROM gl_je_headers glh,
76: gl_je_lines gll,
77: ce_gl_accounts_ccid cega,
78: ce_bank_acct_uses_all cebau,
79: ce_bank_accounts ceba
80: WHERE cega.bank_acct_use_id = cebau.bank_acct_use_id

Line 151: gl_je_lines gll,

147: AND (api.org_id = b_org_id OR api.org_id IS NULL);
148: --SRW.message(1, to_char(NVL(amt, 0)));
149: SELECT SUM(accounted_cr) INTO amt1
150: FROM gl_je_headers glh,
151: gl_je_lines gll,
152: ce_gl_accounts_ccid cega,
153: ce_bank_acct_uses_all cebau,
154: ce_bank_accounts ceba
155: WHERE cega.bank_acct_use_id = cebau.bank_acct_use_id