APPS.EDW_SICM_SIC_HOOK dependencies on EDW_SICM_SIC_LTC

Line 16: from EDW_SICM_SIC_LTC SIC

12: -- Updating FII_AP_HOLD_DATA_F
13: Update FII_AP_HOLD_DATA_F Fact
14: set (SIC_CODE_FK_KEY) =
15: (select SIC.SIC_CODE_PK_KEY
16: from EDW_SICM_SIC_LTC SIC
17: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
18: where (Fact.Supplier_FK_Key IN
19: (select TPartner_Loc_PK_Key
20: from POA_DNB_SIC_CODE Com,

Line 31: from EDW_SICM_SIC_LTC SIC

27: -- Updating FII_AP_INV_ON_HOLD_F
28: Update FII_AP_INV_ON_HOLD_F Fact
29: set (SIC_CODE_FK_KEY) =
30: (select SIC.SIC_CODE_PK_KEY
31: from EDW_SICM_SIC_LTC SIC
32: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
33: where (Fact.Supplier_FK_Key IN
34: (select TPartner_Loc_PK_Key
35: from POA_DNB_SIC_CODE Com,

Line 46: from EDW_SICM_SIC_LTC SIC

42: -- Updating FII_AP_INV_LINES_F
43: Update FII_AP_INV_LINES_F Fact
44: set (SIC_CODE_FK_KEY) =
45: (select SIC.SIC_CODE_PK_KEY
46: from EDW_SICM_SIC_LTC SIC
47: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
48: where (Fact.Supplier_FK_Key IN
49: (select TPartner_Loc_PK_Key
50: from POA_DNB_SIC_CODE Com,

Line 61: from EDW_SICM_SIC_LTC SIC

57: -- Updating FII_AP_INV_PAYMTS_F
58: Update FII_AP_INV_PAYMTS_F Fact
59: set (SIC_CODE_FK_KEY) =
60: (select SIC.SIC_CODE_PK_KEY
61: from EDW_SICM_SIC_LTC SIC
62: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
63: where (Fact.Supplier_FK_Key IN
64: (select TPartner_Loc_PK_Key
65: from POA_DNB_SIC_CODE Com,

Line 76: from EDW_SICM_SIC_LTC SIC

72: -- Updating FII_AP_SCH_PAYMTS_F
73: Update FII_AP_SCH_PAYMTS_F Fact
74: set (SIC_CODE_FK_KEY) =
75: (select SIC.SIC_CODE_PK_KEY
76: from EDW_SICM_SIC_LTC SIC
77: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
78: where (Fact.Supplier_FK_Key IN
79: (select TPartner_Loc_PK_Key
80: from POA_DNB_SIC_CODE Com,