APPS.OPI_DBI_COGS_OPM_PKG dependencies on OPI_DBI_COGS_RUN_LOG

Line 66: FROM opi_dbi_cogs_run_log l,

62:
63:
64: SELECT NVL(MIN(from_date), global_start_date) INTO l_from_date
65: FROM (SELECT tst.gl_trans_date from_date
66: FROM opi_dbi_cogs_run_log l,
67: gl_subr_tst tst
68: WHERE l.source = OPM_SOURCE
69: AND tst.subledger_id = l.start_txn_id
70: UNION

Line 72: FROM opi_dbi_cogs_run_log l,

68: WHERE l.source = OPM_SOURCE
69: AND tst.subledger_id = l.start_txn_id
70: UNION
71: SELECT tst.gl_trans_date from_date
72: FROM opi_dbi_cogs_run_log l,
73: gl_subr_led tst
74: WHERE l.source = OPM_SOURCE
75: AND tst.subledger_id = l.start_txn_id
76: );

Line 651: FROM opi_dbi_cogs_run_log

647: -- 1. get subledger cogs
648:
649: BEGIN
650: SELECT start_txn_id INTO l_last_trx_id
651: FROM opi_dbi_cogs_run_log
652: WHERE source = OPM_SOURCE;
653:
654:
655: SELECT NVL(MAX(subledger_id),l_last_trx_id)

Line 700: merge INTO opi_dbi_cogs_run_log l

696: l_batch_to_id,
697: l_status,
698: l_msg );
699:
700: merge INTO opi_dbi_cogs_run_log l
701: using ( SELECT NULL organization_id,
702: OPM_SOURCE extraction_type
703: FROM dual ) d
704: ON ( l.source = d.extraction_type )

Line 806: merge INTO opi_dbi_cogs_run_log l

802: l_status,
803: l_msg ,
804: p_degree);
805:
806: merge INTO opi_dbi_cogs_run_log l
807: using ( SELECT NULL organization_id,
808: OPM_SOURCE extraction_type
809: FROM dual ) d
810: ON ( l.source = d.extraction_type )