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