APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_ST_PARTNER_CONTACTS

Line 2187: MSC_ST_PARTNER_CONTACTS pc

2183: pc.ENABLED_FLAG,
2184: pc.DELETED_FLAG
2185: FROM MSC_TP_ID_LID til,
2186: MSC_TP_SITE_ID_LID tsil,
2187: MSC_ST_PARTNER_CONTACTS pc
2188: WHERE pc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2189: AND pc.DELETED_FLAG in (1, 2)
2190: AND til.sr_tp_id(+)= pc.partner_id
2191: AND til.partner_type(+)= DECODE( pc.PARTNER_TYPE,1,1,2,2,NULL)