DBA Data[Home] [Help]

APPS.ZX_GL_EXTRACT_PKG dependencies on GL_JE_HEADERS

Line 902: gl_je_headers gjh,

898: zx_taxes_vl zx_tax,
899: gl_code_combinations gcc1,
900: gl_je_lines gjl1,
901: gl_je_batches gjb,
902: gl_je_headers gjh,
903: gl_period_statuses gps ';
904:
905: l_where_clause_gl :=
906: ' WHERE gps.ledger_id = '||to_char(g_ledger_id)||

Line 1114: gl_je_headers gjh,

1110: zx_taxes_vl zx_tax,
1111: gl_code_combinations gcc1,
1112: gl_je_lines gjl1,
1113: gl_je_batches gjb,
1114: gl_je_headers gjh,
1115: gl_period_statuses gps ';
1116:
1117: l_where_clause_gl :=
1118: ' WHERE gps.ledger_id = '||to_char(g_ledger_id)||

Line 1302: GL_JE_HEADERS GJH

1298: GL_JE_LINES GJL2,
1299: -- AR_AP_TAX_CODES_V TAX,
1300: ZX_RATES_VL ZX_RATE,
1301: GL_JE_LINES GJL1,
1302: GL_JE_HEADERS GJH
1303: where gjh.je_header_id = p_trx_id and
1304: gjh.je_header_id = gjl1.je_header_id and
1305: gjl1.tax_code_id = NVL(ZX_RATE.SOURCE_ID,ZX_RATE.TAX_RATE_ID)
1306: AND ((ZX_RATE.TAX_CLASS IN ('OUTPUT','INPUT'))