APPS.PN_SCHEDULES_ITEMS dependencies on PN_LOCATIONS_ALL

Line 3082: l_location_id pn_locations_all.location_id%TYPE;

3078: )
3079: IS
3080:
3081: l_tenancy_Id pn_tenancies_all.tenancy_id%TYPE;
3082: l_location_id pn_locations_all.location_id%TYPE;
3083: l_location_code pn_locations_all.location_code%TYPE;
3084: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
3085: l_action VARCHAR2(30) := NULL;
3086: l_message VARCHAR2(30) := NULL;

Line 3083: l_location_code pn_locations_all.location_code%TYPE;

3079: IS
3080:
3081: l_tenancy_Id pn_tenancies_all.tenancy_id%TYPE;
3082: l_location_id pn_locations_all.location_id%TYPE;
3083: l_location_code pn_locations_all.location_code%TYPE;
3084: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
3085: l_action VARCHAR2(30) := NULL;
3086: l_message VARCHAR2(30) := NULL;
3087: l_tenancy_str_date DATE;

Line 3084: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;

3080:
3081: l_tenancy_Id pn_tenancies_all.tenancy_id%TYPE;
3082: l_location_id pn_locations_all.location_id%TYPE;
3083: l_location_code pn_locations_all.location_code%TYPE;
3084: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
3085: l_action VARCHAR2(30) := NULL;
3086: l_message VARCHAR2(30) := NULL;
3087: l_tenancy_str_date DATE;
3088: l_tenancy_end_date DATE;

Line 3110: FROM pn_locations_all pnl

3106:
3107: CURSOR get_location_type_csr (p_location_id NUMBER, p_start_date DATE) IS
3108: SELECT location_code,
3109: location_type_lookup_code
3110: FROM pn_locations_all pnl
3111: WHERE pnl.location_id = p_location_id
3112: AND p_start_date BETWEEN pnl.active_start_date AND pnl.active_end_date;
3113:
3114: BEGIN