APPS.PN_SCHEDULES_ITEMS dependencies on PN_TENANCIES_ALL

Line 3846: l_tenancy_Id pn_tenancies_all.tenancy_id%TYPE;

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

Line 3862: FROM pn_tenancies_all pnt

3858: location_id,
3859: occupancy_date,
3860: estimated_occupancy_date,
3861: expiration_date
3862: FROM pn_tenancies_all pnt
3863: WHERE pnt.lease_id = p_lease_id
3864: AND NVL(pnt.occupancy_date, pnt.estimated_occupancy_date) > p_new_lea_term_dt;
3865:
3866: CURSOR get_update_tenancies_csr IS

Line 3868: FROM pn_tenancies_all pnt

3864: AND NVL(pnt.occupancy_date, pnt.estimated_occupancy_date) > p_new_lea_term_dt;
3865:
3866: CURSOR get_update_tenancies_csr IS
3867: SELECT *
3868: FROM pn_tenancies_all pnt
3869: WHERE pnt.lease_id = p_lease_id
3870: AND pnt.expiration_date > p_new_lea_term_dt;
3871:
3872: CURSOR get_location_type_csr (p_location_id NUMBER, p_start_date DATE) IS

Line 3998: UPDATE pn_tenancies_all

3994: pnp_debug_pkg.put_log_msg(fnd_message.get);
3995: pnp_debug_pkg.put_log_msg('********************************************************************************');
3996: ELSE
3997:
3998: UPDATE pn_tenancies_all
3999: SET expiration_date = p_new_lea_term_dt,
4000: fin_oblig_end_date = p_new_lea_term_dt,
4001: last_update_date = SYSDATE,
4002: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),