DBA Data[Home] [Help]

APPS.AHL_FMP_COMMON_PVT dependencies on AHL_MR_INTERVALS_APP_V

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: