DBA Data[Home] [Help]

APPS.MSC_SCH_WB dependencies on MSC_APPS_INSTANCES

Line 959: FROM msc_apps_instances mai, msc_assignment_sets mas

955: IF x_assignment_set_id IS NULL THEN
956:
957: SELECT mas.assignment_set_id,mas.assignment_set_name
958: INTO x_assignment_set_id, x_assignment_set_name
959: FROM msc_apps_instances mai, msc_assignment_sets mas
960: WHERE mai.instance_id = x_sr_instance_id
961: AND mas.assignment_set_id = mai.assignment_set_id
962: AND mas.sr_instance_id = mai.instance_id;
963: