APPS.WMS_LMS_LABOR_PRODUCTIVITY dependencies on WMS_ELS_GROUPED_TASKS_GTMP

Line 629: INSERT INTO WMS_ELS_GROUPED_TASKS_GTMP

625: END IF;
626:
627:
628:
629: INSERT INTO WMS_ELS_GROUPED_TASKS_GTMP
630: (
631: els_grouped_task_id,
632: organization_id,
633: activity_id,

Line 776: l_sql:= ' UPDATE WMS_ELS_GROUPED_TASKS_GTMP '

772:
773: -- flush out l_sql so that it does not hold any old values
774: l_sql:= NULL;
775:
776: l_sql:= ' UPDATE WMS_ELS_GROUPED_TASKS_GTMP '
777: || ' SET els_group_id = :els_group_id '
778: || ' where els_group_id IS NULL '
779: || l_where_clause ;
780:

Line 883: SELECT avg(sum_travel_time) into l_avg_travel_time from WMS_ELS_GROUPED_TASKS_GTMP

879: LOOP
880: FETCH c_els_grouped_data_id INTO l_group_data_id;
881: EXIT WHEN c_els_grouped_data_id%NOTFOUND;
882:
883: SELECT avg(sum_travel_time) into l_avg_travel_time from WMS_ELS_GROUPED_TASKS_GTMP
884: WHERE els_group_id = l_group_data_id.els_group_id;
885:
886:
887: IF( l_avg_travel_time IS NOT NULL) THEN