DBA Data[Home] [Help]

APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKX_CONTRACTS_V

Line 185: FROM OKX_CONTRACTS_V cnt

181: SELECT cnt.id1,
182: cnt.id2,
183: cnt.name,
184: cnt.description
185: FROM OKX_CONTRACTS_V cnt
186: WHERE cnt.SCS_CODE IN ('LEASE','LOAN')
187: AND NVL(cnt.ORG_ID, -99) = mo_global.get_current_org_id
188: AND cnt.name = NVL(p_name,cnt.name)
189: AND cnt.id1 = NVL(p_id1,cnt.id1)

Line 9166: from OKX_CONTRACTS_V OKX_LEASE

9162: CURSOR lease_csr IS
9163:
9164: SELECT '1'
9165:
9166: from OKX_CONTRACTS_V OKX_LEASE
9167:
9168: where OKX_LEASE.SCS_CODE IN ('LEASE','LOAN') AND NVL(OKX_LEASE.ORG_ID, -99) = mo_global.get_current_org_id
9169:
9170: AND ID1 = p_id1