APPS.MSC_SCH_WB dependencies on MSC_ASSIGNMENT_SETS

Line 804: ' from msc_assignment_sets'||l_dblink||' '||

800: END IF;
801:
802: sqlstring :=
803: ' select assignment_set_id '||
804: ' from msc_assignment_sets'||l_dblink||' '||
805: ' where sr_instance_id = :x_sr_instance_id '||
806: ' and sr_assignment_set_id = :x_assignment_set_id';
807: execute immediate sqlstring INTO l_msc_assign_set_id
808: using x_sr_instance_id, x_assignment_set_id;

Line 887: ' FROM msc_assignment_sets' ||l_dblink||' '||

883: get_profile('MSC_ATP_ASSIGN_SET', x_assignment_set_id);
884:
885: sqlstring :=
886: ' SELECT assignment_set_name '||
887: ' FROM msc_assignment_sets' ||l_dblink||' '||
888: ' WHERE assignment_set_id = :x_assignment_set_id '||
889: ' AND sr_instance_id = :x_sr_instance_id';
890: execute immediate sqlstring INTO l_assign_name
891: using x_assignment_set_id, x_sr_instance_id;

Line 934: ' from msc_assignment_sets'||l_dblink||' '||

930: -- end if; -- check mrp assignment set for region level sourcing
931:
932: sqlstring :=
933: ' select assignment_set_id '||
934: ' from msc_assignment_sets'||l_dblink||' '||
935: ' where sr_instance_id = :x_sr_instance_id '||
936: ' and sr_assignment_set_id = :x_assignment_set_id';
937: execute immediate sqlstring INTO l_assign_set_id
938: using x_sr_instance_id, x_assignment_set_id;

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:

Line 970: FROM msc_assignment_sets mas

966: END IF;
967: ELSE
968: SELECT mas.assignment_set_name
969: INTO x_assignment_set_name
970: FROM msc_assignment_sets mas
971: WHERE mas.assignment_set_id = x_assignment_set_id
972: AND mas.sr_instance_id = x_sr_instance_id;
973:
974: IF x_assignment_set_name IS NULL THEN