DBA Data[Home] [Help]

APPS.AHL_FMP_MR_INTERVAL_PVT dependencies on AHL_MR_EFFECTIVITIES

Line 367: FROM AHL_MR_EFFECTIVITIES_V

363: item_number,
364: position_item_number ),
365: relationship_id,
366: position_ref_meaning
367: FROM AHL_MR_EFFECTIVITIES_V
368: WHERE mr_effectivity_id = c_mr_effectivity_id;
369:
370: BEGIN
371: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1463: FROM AHL_MR_EFFECTIVITIES_APP_V

1459: IS
1460: SELECT threshold_date,
1461: program_duration,
1462: program_duration_uom_code
1463: FROM AHL_MR_EFFECTIVITIES_APP_V
1464: WHERE mr_effectivity_id = c_mr_effectivity_id;
1465:
1466: l_old_rec threshold_rec_type;
1467:

Line 1680: UPDATE AHL_MR_EFFECTIVITIES SET

1676: END IF;
1677:
1678:
1679: -- Update the record
1680: UPDATE AHL_MR_EFFECTIVITIES SET
1681: object_version_number = object_version_number + 1,
1682: threshold_date = p_x_threshold_rec.threshold_date,
1683: program_duration = p_x_threshold_rec.program_duration,
1684: program_duration_uom_code = p_x_threshold_rec.program_duration_uom_code,