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_REC_CALC_PKG dependencies on PN_LEASES_ALL

Line 99: FROM pn_leases_all

95:
96: CURSOR csr_get_lease IS
97: SELECT name,
98: lease_num
99: FROM pn_leases_all
100: WHERE lease_id = p_lease_id;
101:
102: CURSOR csr_get_location IS
103: SELECT location_code

Line 4173: FROM pn_leases_all

4169:
4170:
4171: CURSOR org_cur IS
4172: SELECT org_id
4173: FROM pn_leases_all
4174: WHERE lease_id = p_lease_id;
4175:
4176: l_org_id NUMBER;
4177:

Line 4198: FROM pn_leases_all pl

4194: SELECT pl.lease_class_code
4195: ,pld.lease_change_id
4196: INTO l_lease_class_code
4197: ,l_lease_change_id
4198: FROM pn_leases_all pl
4199: ,pn_lease_details_all pld
4200: WHERE pl.lease_id = pld.lease_id
4201: AND pld.lease_id = p_lease_id;
4202: