eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_INDEX_RENT_PERIODS_PKG dependencies on PN_LEASES_ALL

Line 1797: FROM pn_leases_all

1793: WHERE lease_id = p_lease_id;
1794:
1795: CURSOR get_lease_num IS
1796: SELECT lease_num
1797: FROM pn_leases_all
1798: WHERE lease_id = p_lease_id;
1799:
1800: CURSOR get_appr_terms_to_extend(p_index_lease_id IN NUMBER) IS
1801: SELECT *

Line 1833: l_lease_num PN_LEASES_ALL.lease_num%TYPE;

1829: l_old_ls_end_date DATE := NULL;
1830: l_ls_comm_dt DATE ;
1831: l_mths NUMBER;
1832: l_requestId NUMBER := NULL;
1833: l_lease_num PN_LEASES_ALL.lease_num%TYPE;
1834: l_ri_term_rec pn_payment_terms_all%ROWTYPE;
1835: v_end_date DATE; -- added for bug #11671285
1836: l_period_id pn_payment_terms_all.index_period_id%TYPE; /* 9263195 */ -- added for bug #11671285
1837: l_basis_type PN_INDEX_LEASES_ALL.BASIS_TYPE%TYPE; -- added for bug #11671285

Line 2321: FROM pn_leases_all pl, pn_index_leases_all pil, pn_index_lease_periods_all pilp

2317: ,pilp.basis_end_date
2318: ,pilp.line_number
2319: ,pil.initial_basis
2320: ,pil.retain_initial_basis_flag
2321: FROM pn_leases_all pl, pn_index_leases_all pil, pn_index_lease_periods_all pilp
2322: WHERE pl.lease_id = pil.lease_id
2323: AND pil.index_lease_id = pilp.index_lease_id
2324: AND pl.lease_id=p_lease_id
2325: AND exists(SELECT 'x'

Line 2425: pn_leases_all lease

2421: changes.change_commencement_date amd_comm_date
2422: FROM pn_lease_details_all details,
2423: pn_lease_details_history det_history,
2424: pn_lease_changes_all changes,
2425: pn_leases_all lease
2426: WHERE details.lease_id = p_lease_id
2427: AND det_history.lease_id = p_lease_id
2428: AND changes.lease_id = p_lease_id
2429: AND lease.lease_id = p_lease_id