APPS.PN_VAR_RENT_PKG dependencies on PN_LEASE_DETAILS_HISTORY

Line 10055: FROM pn_lease_details_history

10051:
10052: /* Fetches the max lease change id */
10053: CURSOR max_lease_change_id_cur IS
10054: SELECT max(lease_change_id) max_lease_change_id
10055: FROM pn_lease_details_history
10056: WHERE lease_id = p_lease_id;
10057:
10058: /* Fetches the old termination date for change id mentioned by the user */
10059: CURSOR old_term_date_cur IS

Line 10061: FROM pn_lease_details_history

10057:
10058: /* Fetches the old termination date for change id mentioned by the user */
10059: CURSOR old_term_date_cur IS
10060: SELECT lease_termination_date
10061: FROM pn_lease_details_history
10062: WHERE lease_id = p_lease_id
10063: AND new_lease_change_id = p_lease_change_id;
10064:
10065: /* Fetches the new termination date for change id mentioned by the user */

Line 10068: FROM pn_lease_details_history

10064:
10065: /* Fetches the new termination date for change id mentioned by the user */
10066: CURSOR new_term_date_cur IS
10067: SELECT lease_termination_date
10068: FROM pn_lease_details_history
10069: WHERE lease_id = p_lease_id
10070: AND lease_change_id = p_lease_change_id;
10071:
10072: /* Fetches the current termination date from lease details table */

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

10118: RAISE MISSING_CHANGE_ID_EXCEPTION;
10119:
10120: ELSIF (l_max_lease_change_id IS NOT NULL AND p_lease_change_id IS NOT NULL) THEN
10121:
10122: /* Fetch the old termination date from pn_lease_details_history tables
10123: for the last amendment */
10124: FOR rec IN old_term_date_cur LOOP
10125: l_old_date := rec.lease_termination_date;
10126: END LOOP;

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

10124: FOR rec IN old_term_date_cur LOOP
10125: l_old_date := rec.lease_termination_date;
10126: END LOOP;
10127:
10128: /* Fetch the new termination date from pn_lease_details_history table */
10129: FOR new_term_date_rec IN new_term_date_cur LOOP
10130: l_new_date := new_term_date_rec.lease_termination_date;
10131: END LOOP;
10132: