APPS.OKL_LOP_PVT dependencies on OKL_LEASE_OPPS_ALL_B

Line 12: WHERE NOT EXISTS (SELECT NULL FROM OKL_LEASE_OPPS_ALL_B B WHERE B.ID =T.ID);

8:
9: BEGIN
10:
11: DELETE FROM OKL_LEASE_OPPORTUNITIES_TL T
12: WHERE NOT EXISTS (SELECT NULL FROM OKL_LEASE_OPPS_ALL_B B WHERE B.ID =T.ID);
13:
14: UPDATE OKL_LEASE_OPPORTUNITIES_TL T
15: SET (SHORT_DESCRIPTION,
16: DESCRIPTION,