APPS.PN_SCHEDULES_ITEMS dependencies on PN_TENANCIES_ALL

Line 3081: l_tenancy_Id pn_tenancies_all.tenancy_id%TYPE;

3077: ,p_new_lea_term_dt DATE
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;

Line 3097: FROM pn_tenancies_all pnt

3093: location_id,
3094: occupancy_date,
3095: estimated_occupancy_date,
3096: expiration_date
3097: FROM pn_tenancies_all pnt
3098: WHERE pnt.lease_id = p_lease_id
3099: AND NVL(pnt.occupancy_date, pnt.estimated_occupancy_date) > p_new_lea_term_dt;
3100:
3101: CURSOR get_update_tenancies_csr IS

Line 3103: FROM pn_tenancies_all pnt

3099: AND NVL(pnt.occupancy_date, pnt.estimated_occupancy_date) > p_new_lea_term_dt;
3100:
3101: CURSOR get_update_tenancies_csr IS
3102: SELECT *
3103: FROM pn_tenancies_all pnt
3104: WHERE pnt.lease_id = p_lease_id
3105: AND pnt.expiration_date > p_new_lea_term_dt;
3106:
3107: CURSOR get_location_type_csr (p_location_id NUMBER, p_start_date DATE) IS

Line 3233: UPDATE pn_tenancies_all

3229: pnp_debug_pkg.put_log_msg(fnd_message.get);
3230: pnp_debug_pkg.put_log_msg('********************************************************************************');
3231: ELSE
3232:
3233: UPDATE pn_tenancies_all
3234: SET expiration_date = p_new_lea_term_dt,
3235: fin_oblig_end_date = p_new_lea_term_dt,
3236: last_update_date = SYSDATE,
3237: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),