APPS.PN_LEASE_CHANGES_PKG dependencies on PN_LEASES_ALL
Line 64: FROM pn_leases_all
60: l_return_status VARCHAR2(30) := NULL;
61:
62: CURSOR org_cur IS
63: SELECT org_id 64: FROM pn_leases_all 65: WHERE lease_id = x_lease_id;
66:
67: l_org_id NUMBER;
68:
Line 615: FROM pn_leases_all
611: ELSIF (X_CHANGE_TYPE_LOOKUP_CODE IN ('AMEND', 'EDIT')) THEN
612: BEGIN
613: SELECT name
614: INTO l_leaseName 615: FROM pn_leases_all 616: WHERE lease_id = X_LEASE_ID;
617:
618: SELECT 1
619: INTO l_dummy