APPS.GMF_MIGRATION dependencies on GL_EVNT_PLC

Line 10184: G_Table_name := 'GL_EVNT_PLC';

10180:
10181: BEGIN
10182:
10183: G_Migration_run_id := P_migration_run_id;
10184: G_Table_name := 'GL_EVNT_PLC';
10185: G_Context := 'Event Fiscal Policies Migration';
10186: X_failure_count := 0;
10187:
10188: /********************************

Line 10207: UPDATE gl_evnt_plc a

10203: /*****************************************
10204: * Update rows For Legal Entity *
10205: *****************************************/
10206:
10207: UPDATE gl_evnt_plc a
10208: SET a.legal_entity_id = (
10209: SELECT x.legal_entity_id
10210: FROM gl_plcy_mst x
10211: WHERE x.co_code = a.co_code

Line 10223: UPDATE gl_evnt_plc a

10219: * are merged together to form the LE Event Fiscal Policy records.so we delete the duplicate records *
10220: * from the Event Fiscal Policy tables. *
10221: **************************************************************************************************************/
10222:
10223: UPDATE gl_evnt_plc a
10224: SET a.delete_mark = 1
10225: WHERE a.ROWID NOT IN (
10226: SELECT MIN(x.ROWID)
10227: FROM gl_evnt_plc x

Line 10227: FROM gl_evnt_plc x

10223: UPDATE gl_evnt_plc a
10224: SET a.delete_mark = 1
10225: WHERE a.ROWID NOT IN (
10226: SELECT MIN(x.ROWID)
10227: FROM gl_evnt_plc x
10228: WHERE x.legal_entity_id = a.legal_Entity_id
10229: AND nvl(x.trans_source_type, -1) = nvl(a.trans_source_type, -1)
10230: AND nvl(x.event_type, -1) = nvl(a.event_type, -1)
10231: AND x.delete_mark <> 1

Line 10240: FROM gl_evnt_plc

10236: **********************************************/
10237:
10238: SELECT count(*)
10239: INTO x_failure_count
10240: FROM gl_evnt_plc
10241: WHERE (legal_entity_id IS NULL AND co_code IS NOT NULL);
10242:
10243: IF nvl(x_failure_count,0) > 0 THEN
10244: