DBA Data[Home] [Help]

APPS.ZX_GL_EXTRACT_PKG dependencies on GL_JE_HEADERS

Line 915: gl_je_headers gjh,

911: zx_taxes_vl zx_tax,
912: gl_code_combinations gcc1,
913: gl_je_lines gjl1,
914: gl_je_batches gjb,
915: gl_je_headers gjh,
916: gl_period_statuses gps ';
917:
918: l_where_clause_gl :=
919: ' WHERE gps.ledger_id = '||to_char(g_ledger_id)||

Line 1129: gl_je_headers gjh,

1125: zx_taxes_vl zx_tax,
1126: gl_code_combinations gcc1,
1127: gl_je_lines gjl1,
1128: gl_je_batches gjb,
1129: gl_je_headers gjh,
1130: gl_period_statuses gps ';
1131:
1132: l_where_clause_gl :=
1133: ' WHERE gps.ledger_id = '||to_char(g_ledger_id)||

Line 1318: GL_JE_HEADERS GJH

1314: GL_JE_LINES GJL2,
1315: -- AR_AP_TAX_CODES_V TAX,
1316: ZX_RATES_VL ZX_RATE,
1317: GL_JE_LINES GJL1,
1318: GL_JE_HEADERS GJH
1319: where gjh.je_header_id = p_trx_id and
1320: gjh.je_header_id = gjl1.je_header_id and
1321: gjl1.tax_code_id = NVL(ZX_RATE.SOURCE_ID,ZX_RATE.TAX_RATE_ID)
1322: AND ((zx_rate.tax_class in ('OUTPUT','INPUT')) or