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_LEASE_DETAILS_ALL

Line 237: FROM pn_index_leases_all pil, pn_lease_details_all pld

233: ,pil.termination_date
234: ,pil.assessment_interval
235: ,pil.relationship_default
236: ,pil.basis_percent_default
237: FROM pn_index_leases_all pil, pn_lease_details_all pld
238: WHERE pld.lease_id = pil.lease_id
239: AND pil.index_lease_id = ip_index_lease_id;
240:
241: tlinfo il_rec%ROWTYPE;

Line 896: ,pn_lease_details_all pld

892: ,pil.basis_percent_default
893: ,pil.index_finder_months
894: ,nvl (pil.index_multiplier,1) "INDEX_MULTIPLIER"
895: FROM pn_index_leases pil
896: ,pn_lease_details_all pld
897: WHERE pld.lease_id = pil.lease_id
898: AND ( pil.index_lease_number = p_index_lease_num
899: OR p_index_lease_num IS NULL)
900: ORDER BY pil.index_lease_number;

Line 1033: FROM pn_index_leases_all pil, pn_lease_details_all pld

1029: ,pil.relationship_default
1030: ,pil.basis_percent_default
1031: ,pil.index_finder_months
1032: ,nvl (pil.index_multiplier, 1) "INDEX_MULTIPLIER"
1033: FROM pn_index_leases_all pil, pn_lease_details_all pld
1034: WHERE pld.lease_id = pil.lease_id
1035: AND pil.index_lease_id = p_index_lease_id;
1036:
1037: v_msg VARCHAR2 (100);

Line 1231: FROM pn_index_leases_all pil, pn_lease_details_all pld

1227: ,pil.relationship_default
1228: ,pil.basis_percent_default
1229: ,pil.index_finder_months
1230: ,nvl (pil.index_multiplier, 1) "INDEX_MULTIPLIER"
1231: FROM pn_index_leases_all pil, pn_lease_details_all pld
1232: WHERE pld.lease_id = pil.lease_id
1233: AND pil.index_lease_id = ip_index_lease_id;
1234:
1235: tlinfo il_rec%ROWTYPE;

Line 1786: pn_lease_details_all pld

1782:
1783: CURSOR get_old_ls_end_date IS
1784: SELECT NVL(plh.lease_extension_end_date, plh.lease_termination_date) old_ls_end_date
1785: FROM pn_lease_details_history plh,
1786: pn_lease_details_all pld
1787: WHERE pld.lease_change_id = plh.new_lease_change_id
1788: AND pld.lease_id = p_lease_id;
1789:
1790: CURSOR get_lease_comm_date IS

Line 1792: FROM pn_lease_details_all

1788: AND pld.lease_id = p_lease_id;
1789:
1790: CURSOR get_lease_comm_date IS
1791: SELECT lease_commencement_date
1792: FROM pn_lease_details_all
1793: WHERE lease_id = p_lease_id;
1794:
1795: CURSOR get_lease_num IS
1796: SELECT lease_num

Line 2422: FROM pn_lease_details_all details,

2418: details.lease_commencement_date lease_comm_date,
2419: details.lease_termination_date lease_term_date,
2420: det_history.lease_extension_end_date lease_ext_end_date,
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

Line 2645: FROM pn_lease_details_all

2641: CURSOR get_lease_details IS
2642: SELECT lease_commencement_date,
2643: lease_termination_date,
2644: ROUND(MONTHS_BETWEEN(lease_termination_date,lease_commencement_date))+1 p_mts
2645: FROM pn_lease_details_all
2646: WHERE lease_id IN (SELECT lease_id
2647: FROM pn_index_leases_all
2648: WHERE index_lease_id = p_index_lease_id);
2649: