DBA Data[Home] [Help]

APPS.AHL_FMP_COMMON_PVT dependencies on AHL_MR_INTERVALS_APP_V

Line 1433: FROM AHL_MR_INTERVALS_APP_V A, AHL_MR_EFFECTIVITIES_APP_V B

1429: CURSOR get_intervals( c_mr_header_id NUMBER )
1430: IS
1431: SELECT A.mr_effectivity_id,
1432: A.counter_id
1433: FROM AHL_MR_INTERVALS_APP_V A, AHL_MR_EFFECTIVITIES_APP_V B
1434: WHERE A.mr_effectivity_id = B.mr_effectivity_id
1435: AND B.mr_header_id = c_mr_header_id
1436: GROUP BY A.mr_effectivity_id,
1437: A.counter_id

Line 1443: FROM AHL_MR_INTERVALS_APP_V A, AHL_MR_EFFECTIVITIES_APP_V B

1439:
1440: CURSOR get_interval_range( c_mr_header_id NUMBER )
1441: IS
1442: SELECT 'X'
1443: FROM AHL_MR_INTERVALS_APP_V A, AHL_MR_EFFECTIVITIES_APP_V B
1444: WHERE ( A.start_date IS NOT NULL OR A.start_value IS NOT NULL )
1445: AND A.mr_effectivity_id = B.mr_effectivity_id
1446: AND B.mr_header_id = c_mr_header_id;
1447: