DBA Data[Home] [Help]

APPS.OKL_AM_ARINV_PVT dependencies on OKL_ASSET_CNDTN_LNS_V

Line 60: FROM OKL_ASSET_CNDTN_LNS_V

56: SELECT approved_yn,
57: acs_code,
58: part_name,
59: actual_repair_cost -- SECHAWLA 6797795 Added
60: FROM OKL_ASSET_CNDTN_LNS_V
61: WHERE id = p_acn_id;
62:
63: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
64: l_approved_yn VARCHAR2(1);

Line 232: FROM OKL_ASSET_CNDTN_LNS_V

228: -- Get the condition header details
229: CURSOR l_acd_csr ( p_acn_id IN NUMBER) IS
230: SELECT id,
231: acd_id
232: FROM OKL_ASSET_CNDTN_LNS_V
233: WHERE id = p_acn_id;
234:
235: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
236: l_api_name CONSTANT VARCHAR2(30):= 'Approve_Asset_Repair';