APPS.PN_VAR_RENT_PKG dependencies on PN_LEASE_DETAILS_ALL

Line 10075: FROM pn_lease_details_all

10071:
10072: /* Fetches the current termination date from lease details table */
10073: CURSOR lease_details_cur IS
10074: SELECT lease_termination_date
10075: FROM pn_lease_details_all
10076: WHERE lease_change_id = p_lease_change_id;
10077:
10078: BEGIN
10079: pnp_debug_pkg.log('pn_var_rent_pkg.process_vr_exp_con +Start+ (+)');

Line 10136: pn_lease_details_all table */

10132:
10133: /* If new termination date is null that is the record for the mentioned
10134: change id is not present in the lease details history table then it
10135: implies that it is the current lease record. Thus fetch the date from
10136: pn_lease_details_all table */
10137: IF l_new_date IS NULL THEN
10138:
10139: FOR lease_details_rec IN lease_details_cur LOOP
10140: l_new_date := lease_details_rec.lease_termination_date;