APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_ST_PARTNER_CONTACTS

Line 2193: MSC_ST_PARTNER_CONTACTS pc

2189: pc.ENABLED_FLAG,
2190: pc.DELETED_FLAG
2191: FROM MSC_TP_ID_LID til,
2192: MSC_TP_SITE_ID_LID tsil,
2193: MSC_ST_PARTNER_CONTACTS pc
2194: WHERE pc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2195: AND pc.DELETED_FLAG in (1, 2)
2196: AND til.sr_tp_id(+)= pc.partner_id
2197: AND til.partner_type(+)= DECODE( pc.PARTNER_TYPE,1,1,2,2,NULL)