APPS.PN_LEASE_DETAILS_PKG dependencies on PN_LEASES_ALL

Line 59: FROM pn_leases_all

55:
56:
57: CURSOR org_cur IS
58: SELECT org_id
59: FROM pn_leases_all
60: WHERE lease_id = x_lease_id;
61:
62: l_org_id NUMBER;
63:

Line 217: pn_leases_all pll

213: pll.name,
214: pll.lease_num,
215: pll.lease_status
216: FROM pn_lease_details_all pld,
217: pn_leases_all pll
218: WHERE pld.lease_detail_id = x_lease_detail_id
219: AND pld.lease_id = pll.lease_id
220: FOR UPDATE OF pld.lease_detail_id NOWAIT;
221:

Line 452: pn_leases_all pnl

448: IS
449: CURSOR c2 IS
450: SELECT ldt.*, pnl.name, pnl.lease_num, pnl.lease_status
451: FROM pn_lease_details_all ldt,
452: pn_leases_all pnl
453: WHERE lease_detail_id = x_lease_detail_id
454: AND ldt.lease_id = pnl.lease_id;
455:
456: recInfoForHist c2%ROWTYPE;