DBA Data[Home] [Help]

APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKX_CONTRACTS_V

Line 169: FROM OKX_CONTRACTS_V cnt

165: SELECT cnt.id1,
166: cnt.id2,
167: cnt.name,
168: cnt.description
169: FROM OKX_CONTRACTS_V cnt
170: WHERE cnt.SCS_CODE IN ('LEASE','LOAN')
171: AND NVL(cnt.ORG_ID, -99) = mo_global.get_current_org_id
172: AND cnt.name = NVL(p_name,cnt.name)
173: AND cnt.id1 = NVL(p_id1,cnt.id1)

Line 9104: from OKX_CONTRACTS_V OKX_LEASE

9100: CURSOR lease_csr IS
9101:
9102: SELECT '1'
9103:
9104: from OKX_CONTRACTS_V OKX_LEASE
9105:
9106: where OKX_LEASE.SCS_CODE IN ('LEASE','LOAN') AND NVL(OKX_LEASE.ORG_ID, -99) = mo_global.get_current_org_id
9107:
9108: AND ID1 = p_id1