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 232: FROM pn_index_leases_all pil, pn_lease_details_all pld

228: ,pil.termination_date
229: ,pil.assessment_interval
230: ,pil.relationship_default
231: ,pil.basis_percent_default
232: FROM pn_index_leases_all pil, pn_lease_details_all pld
233: WHERE pld.lease_id = pil.lease_id
234: AND pil.index_lease_id = ip_index_lease_id;
235:
236: tlinfo il_rec%ROWTYPE;

Line 888: ,pn_lease_details_all pld

884: ,pil.basis_percent_default
885: ,pil.index_finder_months
886: ,nvl (pil.index_multiplier,1) "INDEX_MULTIPLIER"
887: FROM pn_index_leases pil
888: ,pn_lease_details_all pld
889: WHERE pld.lease_id = pil.lease_id
890: AND ( pil.index_lease_number = p_index_lease_num
891: OR p_index_lease_num IS NULL)
892: ORDER BY pil.index_lease_number;

Line 1025: FROM pn_index_leases_all pil, pn_lease_details_all pld

1021: ,pil.relationship_default
1022: ,pil.basis_percent_default
1023: ,pil.index_finder_months
1024: ,nvl (pil.index_multiplier, 1) "INDEX_MULTIPLIER"
1025: FROM pn_index_leases_all pil, pn_lease_details_all pld
1026: WHERE pld.lease_id = pil.lease_id
1027: AND pil.index_lease_id = p_index_lease_id;
1028:
1029: v_msg VARCHAR2 (100);

Line 1223: FROM pn_index_leases_all pil, pn_lease_details_all pld

1219: ,pil.relationship_default
1220: ,pil.basis_percent_default
1221: ,pil.index_finder_months
1222: ,nvl (pil.index_multiplier, 1) "INDEX_MULTIPLIER"
1223: FROM pn_index_leases_all pil, pn_lease_details_all pld
1224: WHERE pld.lease_id = pil.lease_id
1225: AND pil.index_lease_id = ip_index_lease_id;
1226:
1227: tlinfo il_rec%ROWTYPE;

Line 1775: pn_lease_details_all pld

1771:
1772: CURSOR get_old_ls_end_date IS
1773: SELECT NVL(plh.lease_extension_end_date, plh.lease_termination_date) old_ls_end_date
1774: FROM pn_lease_details_history plh,
1775: pn_lease_details_all pld
1776: WHERE pld.lease_change_id = plh.new_lease_change_id
1777: AND pld.lease_id = p_lease_id;
1778:
1779: CURSOR get_lease_comm_date IS

Line 1781: FROM pn_lease_details_all

1777: AND pld.lease_id = p_lease_id;
1778:
1779: CURSOR get_lease_comm_date IS
1780: SELECT lease_commencement_date
1781: FROM pn_lease_details_all
1782: WHERE lease_id = p_lease_id;
1783:
1784: CURSOR get_lease_num IS
1785: SELECT lease_num

Line 2296: FROM pn_lease_details_all details,

2292: details.lease_commencement_date lease_comm_date,
2293: details.lease_termination_date lease_term_date,
2294: det_history.lease_extension_end_date lease_ext_end_date,
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

Line 2501: FROM pn_lease_details_all

2497: CURSOR get_lease_details IS
2498: SELECT lease_commencement_date,
2499: lease_termination_date,
2500: ROUND(MONTHS_BETWEEN(lease_termination_date,lease_commencement_date))+1 p_mts
2501: FROM pn_lease_details_all
2502: WHERE lease_id IN (SELECT lease_id
2503: FROM pn_index_leases_all
2504: WHERE index_lease_id = p_index_lease_id);
2505: