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 4088: FROM pn_leases_all

4084:
4085:
4086: CURSOR org_cur IS
4087: SELECT org_id
4088: FROM pn_leases_all
4089: WHERE lease_id = p_lease_id;
4090:
4091: l_org_id NUMBER;
4092:

Line 4113: FROM pn_leases_all pl

4109: SELECT pl.lease_class_code
4110: ,pld.lease_change_id
4111: INTO l_lease_class_code
4112: ,l_lease_change_id
4113: FROM pn_leases_all pl
4114: ,pn_lease_details_all pld
4115: WHERE pl.lease_id = pld.lease_id
4116: AND pld.lease_id = p_lease_id;
4117: