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 1507: FROM AHL_MR_EFFECTIVITIES_APP_V

1503: IS
1504: SELECT threshold_date,
1505: program_duration,
1506: program_duration_uom_code
1507: FROM AHL_MR_EFFECTIVITIES_APP_V
1508: WHERE mr_effectivity_id = c_mr_effectivity_id;
1509:
1510: l_old_rec threshold_rec_type;
1511:

Line 1724: UPDATE AHL_MR_EFFECTIVITIES SET

1720: END IF;
1721:
1722:
1723: -- Update the record
1724: UPDATE AHL_MR_EFFECTIVITIES SET
1725: object_version_number = object_version_number + 1,
1726: threshold_date = p_x_threshold_rec.threshold_date,
1727: program_duration = p_x_threshold_rec.program_duration,
1728: program_duration_uom_code = p_x_threshold_rec.program_duration_uom_code,