APPS.EGO_ITEM_AML_PUB dependencies on DUAL

Line 711: -- deleting an individual line (all parameters are passed here)

707: AND change_line_id = NVL(p_change_line_id, change_line_id)
708: AND implmentation_date IS NULL;
709: ELSE
710: --
711: -- deleting an individual line (all parameters are passed here)
712: --
713: DELETE EGO_MFG_PART_NUM_CHGS
714: WHERE inventory_item_id = p_inventory_item_id
715: AND organization_id = p_organization_id

Line 1165: ||' FROM DUAL';

1161: ||':6, '-- pk3 value NULL
1162: ||':7, '-- pk4 value NULL
1163: ||':8, '-- pk5 value NULL
1164: ||':9 )'--l_party_key
1165: ||' FROM DUAL';
1166: EXECUTE IMMEDIATE l_dynamic_sql INTO l_temp_status
1167: USING IN l_api_version,
1168: IN p_privilege_name,
1169: IN G_EGO_ITEM,

Line 1312: FROM DUAL

1308: IF l_message_name IS NULL THEN
1309: BEGIN
1310: SELECT 'X'
1311: INTO l_return_status
1312: FROM DUAL
1313: WHERE EXISTS
1314: ( SELECT 'Y' FROM ego_mfg_part_num_chgs
1315: WHERE manufacturer_id = p_manufacturer_id
1316: );