APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_ST_PLANNERS

Line 3536: FROM MSC_ST_PLANNERS x

3532: x.ELECTRONIC_MAIL_ADDRESS,
3533: x.EMPLOYEE_ID,
3534: x.CURRENT_EMPLOYEE_FLAG,
3535: x.USER_NAME
3536: FROM MSC_ST_PLANNERS x
3537: WHERE x.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
3538:
3539: /* added this cursor for bug: 1121172 */
3540: CURSOR c2 IS

Line 3545: FROM MSC_ST_PLANNERS x,

3541: SELECT x.USER_NAME,
3542: x.ELECTRONIC_MAIL_ADDRESS,
3543: x.EMPLOYEE_ID,
3544: x.ORGANIZATION_ID
3545: FROM MSC_ST_PLANNERS x,
3546: FND_USER y
3547: WHERE UPPER(x.USER_NAME) = y.USER_NAME
3548: AND x.CURRENT_EMPLOYEE_FLAG = 1
3549: AND x.EMPLOYEE_ID IS NOT NULL