APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on DUAL

Line 1164: FROM DUAL

1160: FORALL i IN INDICES OF l_uom_warning_queue
1161: INSERT INTO po_session_gt(key, num1)
1162: SELECT l_key,
1163: l_uom_warning_queue(i)
1164: FROM DUAL
1165: WHERE EXISTS (SELECT 1
1166: FROM po_line_locations
1167: WHERE po_line_id = x_lines.po_line_id_tbl(i)
1168: AND shipment_type = 'PRICE BREAK')

Line 1588: FROM DUAL

1584: p_attr_values.draft_id_tbl(i),
1585: p_attr_values.ln_po_line_id_tbl(i),
1586: p_attr_values.ln_ip_category_id_tbl(i),
1587: p_attr_values.ln_item_id_tbl(i)
1588: FROM DUAL
1589: WHERE p_attr_values.error_flag_tbl(i) = FND_API.g_FALSE;
1590:
1591: d_position := 20;
1592:

Line 1708: FROM DUAL

1704: p_attr_values_tlp.ln_po_line_id_tbl(i),
1705: p_attr_values_tlp.ln_ip_category_id_tbl(i),
1706: p_attr_values_tlp.ln_item_id_tbl(i),
1707: p_attr_values_tlp.ln_item_desc_tbl(i)
1708: FROM DUAL
1709: WHERE p_attr_values_tlp.error_flag_tbl(i) = FND_API.g_FALSE;
1710:
1711: d_position := 20;
1712:

Line 2216: FROM DUAL

2212: FND_GLOBAL.conc_request_id,
2213: FND_GLOBAL.prog_appl_id,
2214: FND_GLOBAL.conc_program_id,
2215: sysdate
2216: FROM DUAL
2217: WHERE p_headers.error_flag_tbl(i) = FND_API.g_FALSE
2218: AND p_headers.encumbrance_required_flag_tbl(i) = 'Y';
2219: END IF;
2220: