APPS.PN_SCHEDULES_ITEMS dependencies on PN_LOCATIONS_ALL

Line 3847: l_location_id pn_locations_all.location_id%TYPE;

3843: )
3844: IS
3845:
3846: l_tenancy_Id pn_tenancies_all.tenancy_id%TYPE;
3847: l_location_id pn_locations_all.location_id%TYPE;
3848: l_location_code pn_locations_all.location_code%TYPE;
3849: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
3850: l_action VARCHAR2(30) := NULL;
3851: l_message VARCHAR2(30) := NULL;

Line 3848: l_location_code pn_locations_all.location_code%TYPE;

3844: IS
3845:
3846: l_tenancy_Id pn_tenancies_all.tenancy_id%TYPE;
3847: l_location_id pn_locations_all.location_id%TYPE;
3848: l_location_code pn_locations_all.location_code%TYPE;
3849: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
3850: l_action VARCHAR2(30) := NULL;
3851: l_message VARCHAR2(30) := NULL;
3852: l_tenancy_str_date DATE;

Line 3849: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;

3845:
3846: l_tenancy_Id pn_tenancies_all.tenancy_id%TYPE;
3847: l_location_id pn_locations_all.location_id%TYPE;
3848: l_location_code pn_locations_all.location_code%TYPE;
3849: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
3850: l_action VARCHAR2(30) := NULL;
3851: l_message VARCHAR2(30) := NULL;
3852: l_tenancy_str_date DATE;
3853: l_tenancy_end_date DATE;

Line 3875: FROM pn_locations_all pnl

3871:
3872: CURSOR get_location_type_csr (p_location_id NUMBER, p_start_date DATE) IS
3873: SELECT location_code,
3874: location_type_lookup_code
3875: FROM pn_locations_all pnl
3876: WHERE pnl.location_id = p_location_id
3877: AND p_start_date BETWEEN pnl.active_start_date AND pnl.active_end_date;
3878:
3879: BEGIN