APPS.OKL_AM_CUSTOM_RMK_ASSET_PVT dependencies on QP_LIST_HEADERS

Line 62: --FROM QP_LIST_HEADERS_B -- SECHAWLA 08-DEC-04 4047159

58:
59: -- This cursor is used to validate the list_header_id
60: CURSOR l_qplisthdr_csr(cp_list_header_id NUMBER) IS
61: SELECT 'x'
62: --FROM QP_LIST_HEADERS_B -- SECHAWLA 08-DEC-04 4047159
63: FROM QP_LIST_HEADERS -- SECHAWLA 08-DEC-04 4047159
64: WHERE LIST_HEADER_ID = cp_list_header_id;
65:
66:

Line 63: FROM QP_LIST_HEADERS -- SECHAWLA 08-DEC-04 4047159

59: -- This cursor is used to validate the list_header_id
60: CURSOR l_qplisthdr_csr(cp_list_header_id NUMBER) IS
61: SELECT 'x'
62: --FROM QP_LIST_HEADERS_B -- SECHAWLA 08-DEC-04 4047159
63: FROM QP_LIST_HEADERS -- SECHAWLA 08-DEC-04 4047159
64: WHERE LIST_HEADER_ID = cp_list_header_id;
65:
66:
67: -- This cursor is used to get the warehouse for the Order and Line Transaction types

Line 1412: FROM QP_LIST_HEADERS

1408: -- SECHAWLA 08-DEC-04 4047159 : added
1409: -- This cursor is used to get the price list name
1410: CURSOR l_qplisthdr_csr(cp_list_header_id NUMBER) IS
1411: SELECT name
1412: FROM QP_LIST_HEADERS
1413: WHERE LIST_HEADER_ID = cp_list_header_id;
1414:
1415: -- SECHAWLA 08-DEC-04 4047159 : Added
1416: CURSOR l_mtlsystemitems_b(cp_item_id IN NUMBER) IS

Line 1421: l_pricelist_name QP_LIST_HEADERS.name%TYPE;

1417: SELECT segment1
1418: FROM mtl_system_items_b
1419: WHERE inventory_item_id = cp_item_id;
1420:
1421: l_pricelist_name QP_LIST_HEADERS.name%TYPE;
1422: l_item_number VARCHAR2(40);
1423: BEGIN
1424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1425: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_Item_Price_List','Begin(+)');