APPS.PN_INDEX_RENT_PERIODS_PKG dependencies on PN_LEASES_ALL

Line 1786: FROM pn_leases_all

1782: WHERE lease_id = p_lease_id;
1783:
1784: CURSOR get_lease_num IS
1785: SELECT lease_num
1786: FROM pn_leases_all
1787: WHERE lease_id = p_lease_id;
1788:
1789: CURSOR get_appr_terms_to_extend(p_index_lease_id IN NUMBER) IS
1790: SELECT *

Line 1810: l_lease_num PN_LEASES_ALL.lease_num%TYPE;

1806: l_old_ls_end_date DATE := NULL;
1807: l_ls_comm_dt DATE ;
1808: l_mths NUMBER;
1809: l_requestId NUMBER := NULL;
1810: l_lease_num PN_LEASES_ALL.lease_num%TYPE;
1811: l_ri_term_rec pn_payment_terms_all%ROWTYPE;
1812:
1813: BEGIN
1814: put_log('Processing Main Lease Termination Date for Index Rent increases');

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

2191: ,pilp.basis_end_date
2192: ,pilp.line_number
2193: ,pil.initial_basis
2194: ,pil.retain_initial_basis_flag
2195: FROM pn_leases_all pl, pn_index_leases_all pil, pn_index_lease_periods_all pilp
2196: WHERE pl.lease_id = pil.lease_id
2197: AND pil.index_lease_id = pilp.index_lease_id
2198: AND pl.lease_id=p_lease_id
2199: AND exists(SELECT 'x'

Line 2299: pn_leases_all lease

2295: changes.change_commencement_date amd_comm_date
2296: FROM pn_lease_details_all details,
2297: pn_lease_details_history det_history,
2298: pn_lease_changes_all changes,
2299: pn_leases_all lease
2300: WHERE details.lease_id = p_lease_id
2301: AND det_history.lease_id = p_lease_id
2302: AND changes.lease_id = p_lease_id
2303: AND lease.lease_id = p_lease_id