APPS.PN_VAR_RENT_PKG dependencies on PN_LEASE_DETAILS_ALL

Line 10092: FROM pn_lease_details_all

10088:
10089: /* Fetches the current termination date from lease details table */
10090: CURSOR lease_details_cur IS
10091: SELECT lease_termination_date
10092: FROM pn_lease_details_all
10093: WHERE lease_change_id = p_lease_change_id;
10094:
10095: BEGIN
10096: pnp_debug_pkg.log('pn_var_rent_pkg.process_vr_exp_con +Start+ (+)');

Line 10153: pn_lease_details_all table */

10149:
10150: /* If new termination date is null that is the record for the mentioned
10151: change id is not present in the lease details history table then it
10152: implies that it is the current lease record. Thus fetch the date from
10153: pn_lease_details_all table */
10154: IF l_new_date IS NULL THEN
10155:
10156: FOR lease_details_rec IN lease_details_cur LOOP
10157: l_new_date := lease_details_rec.lease_termination_date;