APPS.AHL_FMP_COMMON_PVT dependencies on AHL_MR_EFFECTIVITIES

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:

Line 1828: AHL_MR_EFFECTIVITIES eff

1824: EXISTS (
1825: SELECT 'x'
1826: FROM AHL_UNIT_EFFECTIVITIES_B unit,
1827: CSI_ITEM_INSTANCES csi,
1828: AHL_MR_EFFECTIVITIES eff
1829: where
1830: eff.inventory_item_id = csi.INVENTORY_ITEM_ID
1831: and unit.CSI_ITEM_INSTANCE_ID = csi.instance_id
1832: and unit.program_mr_header_id = c_mr_header_id

Line 1878: AHL_MR_EFFECTIVITIES eff

1874: FROM DUAL
1875: WHERE EXISTS ( SELECT 'x'
1876: FROM AHL_UNIT_EFFECTIVITIES_B unit,
1877: CSI_ITEM_INSTANCES csi,
1878: AHL_MR_EFFECTIVITIES eff
1879: where
1880: eff.inventory_item_id = csi.INVENTORY_ITEM_ID
1881: and unit.CSI_ITEM_INSTANCE_ID = csi.instance_id
1882: and unit.mr_header_id =eff.mr_header_id