APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on DUAL

Line 1259: FROM DUAL

1255: FORALL i IN INDICES OF l_uom_warning_queue
1256: INSERT INTO po_session_gt(key, num1)
1257: SELECT l_key,
1258: l_uom_warning_queue(i)
1259: FROM DUAL
1260: WHERE EXISTS (SELECT 1
1261: FROM po_line_locations
1262: WHERE po_line_id = x_lines.po_line_id_tbl(i)
1263: AND shipment_type = 'PRICE BREAK')

Line 1389: USING dual

1385: -- merge rows for which ip category is to be updated with
1386: -- rows identified above (for which description is to be updated)
1387: FORALL i IN INDICES OF l_ip_cat_id_updated_queue
1388: MERGE INTO po_session_gt merged
1389: USING dual
1390: ON (merged.num3 = l_ip_cat_id_updated_queue(i)
1391: AND merged.key = l_key)
1392: WHEN MATCHED THEN
1393: UPDATE

Line 1782: FROM DUAL

1778: p_attr_values.draft_id_tbl(i),
1779: p_attr_values.ln_po_line_id_tbl(i),
1780: p_attr_values.ln_ip_category_id_tbl(i),
1781: p_attr_values.ln_item_id_tbl(i)
1782: FROM DUAL
1783: WHERE p_attr_values.error_flag_tbl(i) = FND_API.g_FALSE;
1784:
1785: d_position := 20;
1786:

Line 1904: FROM DUAL

1900: p_attr_values_tlp.ln_ip_category_id_tbl(i),
1901: p_attr_values_tlp.ln_item_id_tbl(i),
1902: p_attr_values_tlp.ln_item_desc_tbl(i),
1903: p_attr_values_tlp.ln_item_long_desc_tbl(i) -- Bug7722053
1904: FROM DUAL
1905: WHERE p_attr_values_tlp.error_flag_tbl(i) = FND_API.g_FALSE;
1906:
1907: d_position := 20;
1908:

Line 2452: FROM DUAL

2448: FND_GLOBAL.conc_request_id,
2449: FND_GLOBAL.prog_appl_id,
2450: FND_GLOBAL.conc_program_id,
2451: sysdate
2452: FROM DUAL
2453: WHERE p_headers.error_flag_tbl(i) = FND_API.g_FALSE
2454: AND p_headers.encumbrance_required_flag_tbl(i) = 'Y';
2455: END IF;
2456: