APPS.PNP_UTIL_FUNC dependencies on PN_LOCATIONS

Line 50: office_location_code PN_LOCATIONS.location_code%TYPE,

46: task_name PA_TASKS.task_name%TYPE
47: );
48:
49: TYPE location_name_rec IS RECORD (
50: office_location_code PN_LOCATIONS.location_code%TYPE,
51: office PN_LOCATIONS.office%TYPE,
52: floor_location_code PN_LOCATIONS.location_code%TYPE,
53: floor PN_LOCATIONS.floor%TYPE,
54: building_location_code PN_LOCATIONS.location_code%TYPE,

Line 51: office PN_LOCATIONS.office%TYPE,

47: );
48:
49: TYPE location_name_rec IS RECORD (
50: office_location_code PN_LOCATIONS.location_code%TYPE,
51: office PN_LOCATIONS.office%TYPE,
52: floor_location_code PN_LOCATIONS.location_code%TYPE,
53: floor PN_LOCATIONS.floor%TYPE,
54: building_location_code PN_LOCATIONS.location_code%TYPE,
55: building PN_LOCATIONS.building%TYPE,

Line 52: floor_location_code PN_LOCATIONS.location_code%TYPE,

48:
49: TYPE location_name_rec IS RECORD (
50: office_location_code PN_LOCATIONS.location_code%TYPE,
51: office PN_LOCATIONS.office%TYPE,
52: floor_location_code PN_LOCATIONS.location_code%TYPE,
53: floor PN_LOCATIONS.floor%TYPE,
54: building_location_code PN_LOCATIONS.location_code%TYPE,
55: building PN_LOCATIONS.building%TYPE,
56: property_code PN_PROPERTIES.property_code%TYPE,

Line 53: floor PN_LOCATIONS.floor%TYPE,

49: TYPE location_name_rec IS RECORD (
50: office_location_code PN_LOCATIONS.location_code%TYPE,
51: office PN_LOCATIONS.office%TYPE,
52: floor_location_code PN_LOCATIONS.location_code%TYPE,
53: floor PN_LOCATIONS.floor%TYPE,
54: building_location_code PN_LOCATIONS.location_code%TYPE,
55: building PN_LOCATIONS.building%TYPE,
56: property_code PN_PROPERTIES.property_code%TYPE,
57: property_name PN_PROPERTIES.property_name%TYPE,

Line 54: building_location_code PN_LOCATIONS.location_code%TYPE,

50: office_location_code PN_LOCATIONS.location_code%TYPE,
51: office PN_LOCATIONS.office%TYPE,
52: floor_location_code PN_LOCATIONS.location_code%TYPE,
53: floor PN_LOCATIONS.floor%TYPE,
54: building_location_code PN_LOCATIONS.location_code%TYPE,
55: building PN_LOCATIONS.building%TYPE,
56: property_code PN_PROPERTIES.property_code%TYPE,
57: property_name PN_PROPERTIES.property_name%TYPE,
58: office_park_name PN_LOCATION_PARKS.name%TYPE,

Line 55: building PN_LOCATIONS.building%TYPE,

51: office PN_LOCATIONS.office%TYPE,
52: floor_location_code PN_LOCATIONS.location_code%TYPE,
53: floor PN_LOCATIONS.floor%TYPE,
54: building_location_code PN_LOCATIONS.location_code%TYPE,
55: building PN_LOCATIONS.building%TYPE,
56: property_code PN_PROPERTIES.property_code%TYPE,
57: property_name PN_PROPERTIES.property_name%TYPE,
58: office_park_name PN_LOCATION_PARKS.name%TYPE,
59: region_name PN_LOCATION_PARKS.name%TYPE

Line 90: location_id PN_LOCATIONS_ALL.location_id%type,

86:
87:
88: TYPE space_assignment_rec IS RECORD (
89:
90: location_id PN_LOCATIONS_ALL.location_id%type,
91: assignment_id PN_SPACE_ASSIGN_CUST_ALL.cust_space_assign_id%type,
92: assign_start_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,
93: assign_end_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,
94: allocated_area_pct PN_SPACE_ASSIGN_CUST_ALL.allocated_area_pct%type,