APPS.PN_VAR_RENT_PKG dependencies on PN_LEASE_DETAILS_HISTORY

Line 10072: FROM pn_lease_details_history

10068:
10069: /* Fetches the max lease change id */
10070: CURSOR max_lease_change_id_cur IS
10071: SELECT max(lease_change_id) max_lease_change_id
10072: FROM pn_lease_details_history
10073: WHERE lease_id = p_lease_id;
10074:
10075: /* Fetches the old termination date for change id mentioned by the user */
10076: CURSOR old_term_date_cur IS

Line 10078: FROM pn_lease_details_history

10074:
10075: /* Fetches the old termination date for change id mentioned by the user */
10076: CURSOR old_term_date_cur IS
10077: SELECT lease_termination_date
10078: FROM pn_lease_details_history
10079: WHERE lease_id = p_lease_id
10080: AND new_lease_change_id = p_lease_change_id;
10081:
10082: /* Fetches the new termination date for change id mentioned by the user */

Line 10085: FROM pn_lease_details_history

10081:
10082: /* Fetches the new termination date for change id mentioned by the user */
10083: CURSOR new_term_date_cur IS
10084: SELECT lease_termination_date
10085: FROM pn_lease_details_history
10086: WHERE lease_id = p_lease_id
10087: AND lease_change_id = p_lease_change_id;
10088:
10089: /* Fetches the current termination date from lease details table */

Line 10139: /* Fetch the old termination date from pn_lease_details_history tables

10135: RAISE MISSING_CHANGE_ID_EXCEPTION;
10136:
10137: ELSIF (l_max_lease_change_id IS NOT NULL AND p_lease_change_id IS NOT NULL) THEN
10138:
10139: /* Fetch the old termination date from pn_lease_details_history tables
10140: for the last amendment */
10141: FOR rec IN old_term_date_cur LOOP
10142: l_old_date := rec.lease_termination_date;
10143: END LOOP;

Line 10145: /* Fetch the new termination date from pn_lease_details_history table */

10141: FOR rec IN old_term_date_cur LOOP
10142: l_old_date := rec.lease_termination_date;
10143: END LOOP;
10144:
10145: /* Fetch the new termination date from pn_lease_details_history table */
10146: FOR new_term_date_rec IN new_term_date_cur LOOP
10147: l_new_date := new_term_date_rec.lease_termination_date;
10148: END LOOP;
10149: