APPS.GMP_APS_DS_PULL dependencies on MSC_ST_JOB_OPERATION_NETWORKS

Line 2378: ' INSERT INTO msc_st_job_operation_networks '

2374: rr_index := 0 ;
2375:
2376: /* NAVIN: ------------ START: Complex Route -- Collect Batch Step Dependencies in one insert-select ------------*/
2377: sql_stmt :=
2378: ' INSERT INTO msc_st_job_operation_networks '
2379: || ' ( '
2380: || ' from_op_seq_id, '
2381: || ' to_op_seq_id, '
2382: || ' wip_entity_id, '

Line 2453: INSERT INTO msc_st_job_operation_networks(

2449: /* NAVIN: ----------------------- MTQ with Hardlinks --------------------- */
2450: i := 1 ;
2451: IF stp_var_itm_from_op_seq_id.FIRST > 0 THEN
2452: FORALL i IN stp_var_itm_from_op_seq_id.FIRST..stp_var_itm_from_op_seq_id.LAST
2453: INSERT INTO msc_st_job_operation_networks(
2454: from_op_seq_id,
2455: wip_entity_id,
2456: dependency_type,
2457: transition_type,