APPS.OZF_PRE_PROCESS_PVT dependencies on DUAL

Line 2725: -- INTO l_org_id FROM DUAL;

2721: px_line_record.item_number(i) IS NULL THEN
2722: -- Bug 4520881 (+)
2723: l_org_id := G_ITEM_ORG_ID; --FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
2724: -- SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
2725: -- INTO l_org_id FROM DUAL;
2726: -- Bug 4520881 (-)
2727: OPEN get_item_number( px_line_record.inventory_item_id(i)
2728: , l_org_id);
2729: FETCH get_item_number INTO px_line_record.item_number(i);

Line 6418: FROM DUAL;

6414: ozf_utility_pvt.debug_message('Mapping Type: ' || p_mapping_type);
6415: END IF;
6416: SELECT dbms_utility.get_hash_value( p_external_code_tbl(i),1, 2048)
6417: INTO idx
6418: FROM DUAL;
6419: IF l_temp_code_tbl.exists(idx) THEN
6420: x_internal_code_tbl(i) := l_temp_code_tbl(idx);
6421: IF OZF_DEBUG_LOW_ON THEN
6422: ozf_utility_pvt.debug_message('Internal Code: ' || x_internal_code_tbl(i));

Line 8130: SELECT ozf_resale_logs_all_s.nextval into l_log_id from dual;

8126: --
8127: IF p_error_code IS NOT NULL THEN
8128: BEGIN
8129:
8130: SELECT ozf_resale_logs_all_s.nextval into l_log_id from dual;
8131:
8132: -- julou bug 6317120. get org_id from table
8133: IF p_id_type = 'BATCH' THEN
8134: OPEN OZF_RESALE_COMMON_PVT.gc_batch_org_id(p_id_value);