APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on MTL_TRANSACTION_REASONS

Line 3410: l_reason_name mtl_transaction_reasons.reason_name%type;

3406: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3407:
3408: --Local Variables for search results
3409: l_rownum NUMBER;
3410: l_reason_name mtl_transaction_reasons.reason_name%type;
3411: l_reason_id NUMBER;
3412: l_reason_desc mtl_transaction_reasons.description%type;
3413:
3414: BEGIN

Line 3412: l_reason_desc mtl_transaction_reasons.description%type;

3408: --Local Variables for search results
3409: l_rownum NUMBER;
3410: l_reason_name mtl_transaction_reasons.reason_name%type;
3411: l_reason_id NUMBER;
3412: l_reason_desc mtl_transaction_reasons.description%type;
3413:
3414: BEGIN
3415:
3416: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3421: l_sql_string := l_sql_string || ' FROM mtl_transaction_reasons ';

3417:
3418: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
3419: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, reason_name,';
3420: l_sql_string := l_sql_string || ' reason_id, description ';
3421: l_sql_string := l_sql_string || ' FROM mtl_transaction_reasons ';
3422: l_sql_string := l_sql_string || ' WHERE nvl(disable_date,sysdate) >= sysdate ';
3423:
3424: --Get Dynamic Search Criteria
3425: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;