APPS.AHL_FMP_COMMON_PVT dependencies on AHL_MR_EFFECTIVITIES

Line 1369: FROM AHL_MR_EFFECTIVITIES_APP_V

1365:
1366: CURSOR check_mr_effectivity( c_mr_effectivity_id NUMBER )
1367: IS
1368: SELECT object_version_number
1369: FROM AHL_MR_EFFECTIVITIES_APP_V
1370: WHERE mr_effectivity_id = c_mr_effectivity_id;
1371:
1372: BEGIN
1373: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1425: FROM AHL_MR_EFFECTIVITIES_APP_V

1421:
1422: CURSOR get_threshold( c_mr_header_id NUMBER )
1423: IS
1424: SELECT 'X'
1425: FROM AHL_MR_EFFECTIVITIES_APP_V
1426: WHERE mr_header_id = c_mr_header_id
1427: AND threshold_date IS NOT NULL;
1428:
1429: CURSOR get_intervals( c_mr_header_id NUMBER )

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:

Line 1726: FROM ahl_mr_effectivities_app_v

1722: CURSOR effectivity_id_csr_type(p_mr_effectivity_name IN VARCHAR2,
1723: p_mr_header_id IN NUMBER)
1724: IS
1725: SELECT mr_effectivity_id
1726: FROM ahl_mr_effectivities_app_v
1727: WHERE name = p_mr_effectivity_name
1728: AND
1729: mr_header_id = p_mr_header_id;
1730:

Line 1887: AHL_MR_EFFECTIVITIES eff

1883: EXISTS (
1884: SELECT 'x'
1885: FROM AHL_UNIT_EFFECTIVITIES_B unit,
1886: CSI_ITEM_INSTANCES csi,
1887: AHL_MR_EFFECTIVITIES eff
1888: where
1889: eff.inventory_item_id = csi.INVENTORY_ITEM_ID
1890: and unit.CSI_ITEM_INSTANCE_ID = csi.instance_id
1891: and unit.program_mr_header_id = c_mr_header_id

Line 1937: AHL_MR_EFFECTIVITIES eff

1933: FROM DUAL
1934: WHERE EXISTS ( SELECT 'x'
1935: FROM AHL_UNIT_EFFECTIVITIES_B unit,
1936: CSI_ITEM_INSTANCES csi,
1937: AHL_MR_EFFECTIVITIES eff
1938: where
1939: eff.inventory_item_id = csi.INVENTORY_ITEM_ID
1940: and unit.CSI_ITEM_INSTANCE_ID = csi.instance_id
1941: and unit.mr_header_id =eff.mr_header_id