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 1416: FROM QP_LIST_HEADERS

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

Line 1425: l_pricelist_name QP_LIST_HEADERS.name%TYPE;

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