APPS.AHL_FMP_COMMON_PVT dependencies on AHL_MR_EFFECTIVITIES_APP_V

Line 1349: FROM AHL_MR_EFFECTIVITIES_APP_V

1345:
1346: CURSOR check_mr_effectivity( c_mr_effectivity_id NUMBER )
1347: IS
1348: SELECT object_version_number
1349: FROM AHL_MR_EFFECTIVITIES_APP_V
1350: WHERE mr_effectivity_id = c_mr_effectivity_id;
1351:
1352: BEGIN
1353: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1405: FROM AHL_MR_EFFECTIVITIES_APP_V

1401:
1402: CURSOR get_threshold( c_mr_header_id NUMBER )
1403: IS
1404: SELECT 'X'
1405: FROM AHL_MR_EFFECTIVITIES_APP_V
1406: WHERE mr_header_id = c_mr_header_id
1407: AND threshold_date IS NOT NULL;
1408:
1409: CURSOR get_intervals( c_mr_header_id NUMBER )

Line 1413: FROM AHL_MR_INTERVALS_APP_V A, AHL_MR_EFFECTIVITIES_APP_V B

1409: CURSOR get_intervals( c_mr_header_id NUMBER )
1410: IS
1411: SELECT A.mr_effectivity_id,
1412: A.counter_id
1413: FROM AHL_MR_INTERVALS_APP_V A, AHL_MR_EFFECTIVITIES_APP_V B
1414: WHERE A.mr_effectivity_id = B.mr_effectivity_id
1415: AND B.mr_header_id = c_mr_header_id
1416: GROUP BY A.mr_effectivity_id,
1417: A.counter_id

Line 1423: FROM AHL_MR_INTERVALS_APP_V A, AHL_MR_EFFECTIVITIES_APP_V B

1419:
1420: CURSOR get_interval_range( c_mr_header_id NUMBER )
1421: IS
1422: SELECT 'X'
1423: FROM AHL_MR_INTERVALS_APP_V A, AHL_MR_EFFECTIVITIES_APP_V B
1424: WHERE ( A.start_date IS NOT NULL OR A.start_value IS NOT NULL )
1425: AND A.mr_effectivity_id = B.mr_effectivity_id
1426: AND B.mr_header_id = c_mr_header_id;
1427:

Line 1667: FROM ahl_mr_effectivities_app_v

1663: CURSOR effectivity_id_csr_type(p_mr_effectivity_name IN VARCHAR2,
1664: p_mr_header_id IN NUMBER)
1665: IS
1666: SELECT mr_effectivity_id
1667: FROM ahl_mr_effectivities_app_v
1668: WHERE name = p_mr_effectivity_name
1669: AND
1670: mr_header_id = p_mr_header_id;
1671: