APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on MTL_TRANSACTION_REASONS

Line 3556: l_reason_name mtl_transaction_reasons.reason_name%type;

3552: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3553:
3554: --Local Variables for search results
3555: l_rownum NUMBER;
3556: l_reason_name mtl_transaction_reasons.reason_name%type;
3557: l_reason_id NUMBER;
3558: l_reason_desc mtl_transaction_reasons.description%type;
3559:
3560: BEGIN

Line 3558: l_reason_desc mtl_transaction_reasons.description%type;

3554: --Local Variables for search results
3555: l_rownum NUMBER;
3556: l_reason_name mtl_transaction_reasons.reason_name%type;
3557: l_reason_id NUMBER;
3558: l_reason_desc mtl_transaction_reasons.description%type;
3559:
3560: BEGIN
3561:
3562: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3563:
3564: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
3565: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, reason_name,';
3566: l_sql_string := l_sql_string || ' reason_id, description ';
3567: l_sql_string := l_sql_string || ' FROM mtl_transaction_reasons ';
3568: l_sql_string := l_sql_string || ' WHERE nvl(disable_date,sysdate) >= sysdate ';
3569:
3570: --Get Dynamic Search Criteria
3571: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;