APPS.MTL_CCEOI_ACTION_PUB dependencies on MTL_CYCLE_COUNT_HEADERS

Line 1232: FROM MTL_CYCLE_COUNT_HEADERS

1228: -- Set global variables for container adjustment and discrepancies
1229: SELECT container_enabled_flag, container_adjustment_option, container_discrepancy_option
1230: INTO MTL_CCEOI_VAR_PVT.G_CONTAINER_ENABLED_FLAG, MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION,
1231: MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION
1232: FROM MTL_CYCLE_COUNT_HEADERS
1233: WHERE cycle_count_header_id = p_interface_rec.cycle_count_header_id;
1234: -- If either flag is null if container enabled flag is enabled (1), set to default.
1235: IF MTL_CCEOI_VAR_PVT.G_CONTAINER_ENABLED_FLAG = 1 THEN
1236: MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION := NVL(MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION, 1);

Line 1364: FROM mtl_cycle_count_headers

1360:
1361: -- Check if Unschedualed Entries are allowed.
1362: SELECT unscheduled_count_entry
1363: INTO l_unsched_allowed
1364: FROM mtl_cycle_count_headers
1365: WHERE cycle_count_header_id = p_interface_rec.cycle_count_header_id;
1366:
1367: -- Loop through table for each item.
1368: v_index := l_expl_tbl.FIRST;