DBA Data[Home] [Help]

APPS.AHL_RA_NR_PROFILE_PVT dependencies on AHL_RESOURCES

Line 766: FROM ahl_resources ar

762:
763: CURSOR get_resource_id(c_resource_name VARCHAR2)
764: IS
765: SELECT resource_id
766: FROM ahl_resources ar
767: WHERE ar.name = c_resource_name;
768:
769: CURSOR check_resource_id(c_resource_id NUMBER)
770: IS

Line 772: FROM ahl_resources

768:
769: CURSOR check_resource_id(c_resource_id NUMBER)
770: IS
771: SELECT 'X'
772: FROM ahl_resources
773: WHERE resource_id = c_resource_id;
774:
775: CURSOR get_inventory_item_id(c_item_name VARCHAR2)
776: IS