APPS.GMF_MIGRATION dependencies on GL_EVNT_PLC

Line 10513: G_Table_name := 'GL_EVNT_PLC';

10509:
10510: BEGIN
10511:
10512: G_Migration_run_id := P_migration_run_id;
10513: G_Table_name := 'GL_EVNT_PLC';
10514: G_Context := 'Event Fiscal Policies Migration';
10515: X_failure_count := 0;
10516:
10517: /********************************

Line 10536: UPDATE gl_evnt_plc a

10532: /*****************************************
10533: * Update rows For Legal Entity *
10534: *****************************************/
10535:
10536: UPDATE gl_evnt_plc a
10537: SET a.legal_entity_id = (
10538: SELECT x.legal_entity_id
10539: FROM gl_plcy_mst x
10540: WHERE x.co_code = a.co_code

Line 10552: UPDATE gl_evnt_plc a

10548: * are merged together to form the LE Event Fiscal Policy records.so we delete the duplicate records *
10549: * from the Event Fiscal Policy tables. *
10550: **************************************************************************************************************/
10551:
10552: UPDATE gl_evnt_plc a
10553: SET a.delete_mark = 1
10554: WHERE a.ROWID NOT IN (
10555: SELECT MIN(x.ROWID)
10556: FROM gl_evnt_plc x

Line 10556: FROM gl_evnt_plc x

10552: UPDATE gl_evnt_plc a
10553: SET a.delete_mark = 1
10554: WHERE a.ROWID NOT IN (
10555: SELECT MIN(x.ROWID)
10556: FROM gl_evnt_plc x
10557: WHERE x.legal_entity_id = a.legal_Entity_id
10558: AND nvl(x.trans_source_type, -1) = nvl(a.trans_source_type, -1)
10559: AND nvl(x.event_type, -1) = nvl(a.event_type, -1)
10560: AND x.delete_mark <> 1

Line 10569: FROM gl_evnt_plc

10565: **********************************************/
10566:
10567: SELECT count(*)
10568: INTO x_failure_count
10569: FROM gl_evnt_plc
10570: WHERE (legal_entity_id IS NULL AND co_code IS NOT NULL);
10571:
10572: IF nvl(x_failure_count,0) > 0 THEN
10573: