DBA Data[Home] [Help]

APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on JL_REMIT3_GT

Line 1477: from jl_remit3_gt) where r=1;

1473: decode(event_type_code,'CANCEL_COLL_DOC',2,'CANCEL_FACT_DOC',2,1)) cancel_event_id,
1474: row_number()
1475: over (partition by row_id order by
1476: decode(event_type_code,'CANCEL_COLL_DOC',2,'CANCEL_FACT_DOC',2,1)) r
1477: from jl_remit3_gt) where r=1;
1478:
1479: BEGIN
1480: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1481: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPGRADE_OCCURRENCES','Start procedure UPGRADE_OCCURRENCES');

Line 1913: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Upgrade_Distributions','Create the Journal Entry Events and Headers. Inserting into xla_events, jl_remit1_gt,xla_ae_headers,jl_remit3_gt');

1909: -- are not added for Events, JE Headers, JE Lines and Dist Links
1910: -- because it is assumed that if the data in transaction entities is not
1911: -- present, then data in rest of the tables is also not present.
1912: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1913: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Upgrade_Distributions','Create the Journal Entry Events and Headers. Inserting into xla_events, jl_remit1_gt,xla_ae_headers,jl_remit3_gt');
1914: END IF;
1915:
1916: INSERT ALL
1917: WHEN 1 = 1 THEN

Line 2091: INTO jl_remit3_gt

2087: 222,
2088: 'N'
2089: )
2090: WHEN 1 = 1 THEN
2091: INTO jl_remit3_gt
2092: (
2093: ROW_ID,
2094: EVENT_TYPE_CODE,
2095: EVENT_ID