APPS.PN_SPACE_ALLOCATIONS_PKG dependencies on PNP_UTIL_FUNC

Line 408: SELECT sum(PNP_UTIL_FUNC.get_vacant_area(location_id))

404: ) IS
405:
406: BEGIN
407:
408: SELECT sum(PNP_UTIL_FUNC.get_vacant_area(location_id))
409: INTO x_vacant_area
410: FROM PN_SPACE_ALLOCATIONS_ALL --sdm_MOAC
411: WHERE location_id = x_location_id;
412:

Line 434: SELECT sum(PNP_UTIL_FUNC.get_utilized_capacity(location_id))

430: ) IS
431:
432: BEGIN
433:
434: SELECT sum(PNP_UTIL_FUNC.get_utilized_capacity(location_id))
435: INTO x_utilized_capacity
436: FROM PN_SPACE_ALLOCATIONS_ALL
437: WHERE location_id = x_location_id ;
438: