APPS.GMP_APS_DS_PULL dependencies on MSC_ST_JOB_OPERATION_NETWORKS

Line 2611: ' INSERT INTO msc_st_job_operation_networks '

2607: rr_index := 0 ;
2608:
2609: /* NAVIN: ------------ START: Complex Route -- Collect Batch Step Dependencies in one insert-select ------------*/
2610: sql_stmt :=
2611: ' INSERT INTO msc_st_job_operation_networks '
2612: || ' ( '
2613: || ' from_op_seq_id, '
2614: || ' to_op_seq_id, '
2615: || ' wip_entity_id, '

Line 2699: INSERT INTO msc_st_job_operation_networks(

2695: /* NAVIN: ----------------------- MTQ with Hardlinks --------------------- */
2696: i := 1 ;
2697: IF stp_var_itm_from_op_seq_id.FIRST > 0 THEN
2698: FORALL i IN stp_var_itm_from_op_seq_id.FIRST..stp_var_itm_from_op_seq_id.LAST
2699: INSERT INTO msc_st_job_operation_networks(
2700: from_op_seq_id,
2701: wip_entity_id,
2702: dependency_type,
2703: transition_type,